Exporting Historical data from UIM/UMP in csv/excel

[Siddharth Rai]

Hello All,

i am trying to get the historical data for 30days from UIM/UMP.
When i try that in IM on nas get to see the historical alarms only for 3days.
I want them to get me the data for 30days and also please suggest how can that be exported in CSV/EXCEL because i dont see any option.
Please suggest how could i get that report from IM/UMP.

------------------------------
System Analyst
DXC Techonlogy
------------------------------

[David Michel]

you can query the UIM db NAS_TRANSACTION_SUMMARY table for that.

------------------------------
Support Engineer
Broadcom
------------------------------

[Siddharth Rai]

Hi Dav,

I dont see the exporting option there.

------------------------------
System Analyst
DXC Technology
------------------------------

[Siddharth Rai]

and it does nothing when i try to save from the below option in UMP

------------------------------
System Analyst
DXC Technology
------------------------------

[David Michel]

Correct the UMP SLM portlet does not have an export or copy function.
Need to a database tool for that, such as MS SQL Studio for MS SQL Server. 
But Franklin has a way via UIM.
another way to do the query to show alarms within the last 30 days
select * FROM [CA_UIM].[dbo].[NAS_TRANSACTION_SUMMARY] where created > '2019-06-18 14:00:00.000'
or use nimts instead of created, which every.

------------------------------
Support Engineer
Broadcom
------------------------------

[Siddharth Rai]

And is there any way to export performance reports to csv/xml?

------------------------------
System Analyst
DXC Technology
------------------------------

[Franklin Ravi D'souza]

Please see 

"Export CSV data " in below links 

https://docops.ca.com/ca-unified-infrastructure-management/8-5-1/en/using-ump/the-performance-reports-designer

[Siddharth Rai]

Can i export performance reports for multiple robots at at time ?

I am not much familiar with UMP , can you please send some examples or screenshots ?

------------------------------
System Analyst
DXC Technology
------------------------------

[Franklin Ravi D'souza]

Hi ,

You can check to export the historical alarms from USM portlet in ump

https://docops.ca.com/ca-unified-infrastructure-management/8-5-1/en/using-ump/the-unified-service-manager-portlet/manage-alarms-in-usm#ManageAlarmsinUSM-ExportHistoricalAlarmstoCSV