History Report on CMDB Items

[pszpakowski]

How can I generate a report on the history of an item from CMDB, such as a server or application, based on changes in CMDB? Should I use a data analysis tool like Power BI or Tableau that pulls data from a data warehouse if the data warehouse has ServiceNow data? Where there was maybe a variable input of host name and it would populate the history of that item.  I've done similar in the past in Tableau but also not using ServiceNow data.

[AshishKM]

Hi @pszpakowski , 

ServiceNow has as set of history/audit table which record all changes on record fields ( if audit enabled ). However its not recommended to create a report of those table because of high number of record which will impact the system performance and may cause other users at the same time, also those tables are only available to system admins for reporting ( if configured ). 

You have to think some other alternate for history data reporting. You can pull all CMDB data in other BI application and generate the reports/dashboards.

-Thanks,
AshishKM