What SQL query runs to return the Properties > Audit data for an item?

Products

• IT Management Suite
• Client Management Suite

Issue/Introduction

An admin would like to know where the data comes from that populates the right-click Properties > Audit when selected from the Console.

Environment

ITMS 8.x

Symantec Management Console 8.x

Resolution

The SQL Query that is run to get the Item data is as follows: 

EXECUTE spGetItemAudit @entity='<ItemGUID>', @minDate='<dateTime stamp>', @maxRows=50

 

The stored procedure spGetItemAudit pulls data from the following tables and Unions the data together: Evt_Server_Settings_Audit and Evt_NS_Item_Management: