Query SQL database for deleted computers and who deleted those machines

1

Looking any SQL query to find out who deleted reported machines in Bigfix console.

I gone through below URL from the older post but did’t get the user name whose deleted them.

http://www-01.ibm.com/support/knowledgecenter/SS63NW_9.2.0/com.ibm.tivoli.tem.doc_9.2/Platform/API_Reference/DatabaseAPI/DatabaseAPIIntro.html5
https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/Tivoli%20Endpoint%20Manager/page/Querying%20BigFix%20Data7
http://www-01.ibm.com/support/docview.wss?uid=swg215059502
Automatic/Manual group Creator and modifier Information4
SQL Analyses Properties7

Regards,
Shaban

2

Note that this information (deletion of computers from the Console or API) is tracked in the server audit log as of 9.5.11.

3

Thanks Aram,

Our environment is with 9.5.8 so any SQL query will be with help on this,

Regards,
Shaban

4

Unfortunately, the information as to who deleted a BigFix Computer object is not stored within the database…

5

Thanks Aram,

Regards,
Shaban

1 Like