URL to generate the USM Dynamic Report / Default System Report?

[Daniel Blanco]

Does anyone know, what URL is passed to generate the USM Dynamic Report/Default Report when you select a host and in the Reports drop down menu you get a new window to pop open and it runs that full report on the server? 

I want to use that in another program to pass the machine name and generate this report upon right click. 

[Anon Anon]

Sure!  though I don't know if these are documented, I was able to find them using the browser debugger.  The URL to use would be in the format:

 

http://ump_server/qoschart/jsp/standalone.jsp?user<UMP_USER>&password=<PASSWORD>&name=<URL_ENCODED_NAME_OF_REPORT>&source=<HOSTNAME_OR_IP>&prune=true&height=0&lastPeriod=86400000

 

The key parameters are the name which is the name of the report as specified by the path shown in the dropdown or in the PRD report save path, and the source which is the hostname or IP specified for each device that matches the system in the USM inventory.

 

Note that the report name needs to be URL encoded to handle spaces and slashes.

 

 

Example of URL Encoded name:

 

ReportName: USM Dynamic Report Templates/Default Report

URL Encoded: USM%20Dynamic%20Report%20Templates%2FDefault%20Report

 

Some other examples:

 

http://ump.nimsoft.com/qoschart/jsp/standalone.jsp?user=<UMP_USER>&password=<PASSWORD>&prune=true&name=USM%2520Dynamic%2520Report%2520Templates%252FCloudMonitor%2520Breakdown&cs%5Fid=1148&height=0&lastPeriod=86400000#

 

http://ump.nimsoft.com/qoschart/jsp/standalone.jsp?user=<USER>&password=<PASSWORD>&prune=true&name=USM%20Dynamic%20Report%20Templates%2FDefault%20Report&cs_id=790&height=0&lastPeriod=86400000#

[Daniel Blanco]

Thanks for the reply but I tried this in several ways and it did not work.

The page loads but the report title ends up with just  $name and comes up empty:

I removed the USER= & Pass= b/c it will just prompt you for U/P to login/validate. 

 

If the box name I wanted to report on was called say: NMSServer1 I put the ID as NMSServer1

And the NMS UMP Server was: 10.10.10.10

I tried with the following but all I get is jsut a blank report with $Name  

 

Example:

http://10.10.10.10/qoschart/jsp/standalone.jsp?&name=USM%20Dynamic%20Report%20Templates%2FDefault%20Report&cs_id=NMSServer1&prune=true&height=0&lastPeriod=86400000#

 

What am I missing???

 

Where did you find the details as to what URL gets called to produce the System Summary Report Page? I'd like to look it if possible and try to figure it out. 

[Anon Anon]

You need to link to the Server Performance report, not the Default Report.You were close, just follow the PRD report structure and pass the cs_id of the device you want the metrics for. YOu can get the cs_id from the CM_COMPUTER_SYSTEM table.

 

http://10.10.10.10/qoschart/jsp/standalone.jsp?name=USM%2520Dynamic%2520Report%2520Templates%252FServer%2520Performance&cs_id=1&height=0&lastPeriod=86400000#

 

 

[Daniel Blanco]

Thanks Bryan, is there any other way to get the CS_ID or maybe another way to pass the URL via the hostname? I'm trying to get this working via a r-click menu option and I can pass the $HOST_NAME or $IP_ADDRESS but getting the CS_ID isn't something that is part of the CI within that other product. 

 

[Anon Anon]

I figured it out, use &source=SERVERNAME instead of cs_id=

[Anon Anon]

Great Catch Bryan, I've updated the initial response with this info.

Dblanco, Does this work for you? and if so, can you mark it as a solution?  Also I've raised this with support to add better documentation about qoscharts/standalone.jsp page.

 

Best Regards,
Ryan

[Daniel Blanco]

I just tired this and it's still not working. 
I got the cs_id of the system I'm trying for test purposes via a SLM query to our DB to load the report on but when i try by source it doesn't work. 

 

example: Hostname/Server Name:   nms-na-hub01.alpha.com

CS_ID: 5

 

I tried with cs_id with this URL and that works:

http://10.10.10.10/qoschart/jsp/standalone.jsp?&name=USM%2520Dynamic%2520Report%2520Templates%252FServer%2520Performance&cs_id=5&height=0&lastPeriod=86400000#

 

I tried with &source=nms-na-hub01.alpha.com and doesn't load data:

http://10.10.10.10/qoschart/jsp/standalone.jsp?&name=USM%2520Dynamic%2520Report%2520Templates%252FServer%2520Performance&source=nms-na-hub01.alpha.com&lastPeriod=86400000#

 

This is the exact name in the SLM query from the name column in the CM_COMPUTER_SYSTEM table. 

 

Also from the QoS Help Doc, it says we can specify the user & password in the url after the jsp? with &user=  and &password=

http://<ump_server>/qoschart/jsp/standalone.jsp?user=<user>&password=<pass>

I created a very limited ACL just for running UMP reports and set the user: rptusr  & password = rptPW 

 

I tried specifying this in the URL so I don't get prompted every single time I try to test this, but this doens't work either.

+User & PW:    &user=rptusr&password=rptPW

 

So i tried it with with the cs_id url above (since that works) and still get prompted for Login Credentials: (When I enter the same info it logs in):

http://10.10.10.10/qoschart/jsp/standalone.jsp?&user=rptusr&password=rptPW&name=USM%2520Dynamic%2520Report%2520Templates%252FServer%2520Performance&cs_id=5&lastPeriod=86400000#

 

[Anon Anon]

The way in which qos data is collected allows for differences in hostnames and IP addresses in the source. Can you open a performance report designer and add one of the metrics from this server.  It may be that the system is using the shortname, or the ip address as the "source" of the qos data.  You can find the ssource in the legend as shown here:

 

You will need to match the source name shown here with that of your URL parameter &source=<SOURCE_NAME>.  For reference the source can be configured in the cdm probe configuration.

[Daniel Blanco]

Hi, were you able to specify a user & pass in the URL and get that to work? I created a user just for this purpose but its' not working. 

[Daniel Blanco]

bump

 

[Anon Anon]

What ACL permissions does the user have? If you put your credentials in the &user and &password fields does that work? If you take the credentials out of the link and try to sign-in as that user when prompted does that work?

[Daniel Blanco]

Doh! Figured it out as the problem was that we set UMP to only allow login with U@D. I specified just U: soi I put the @ part on and now it works...
Thank you....

[Daniel Blanco]

You forgot the = after the user part in the url example above..