Really need a Task or Fixlet that help me get a list of computers that have been deleted when using the “Remove from Database” option. I know BigFix warehouses this information somewhere, but I’m lost as to how to get at it.
BigFix Pro’s, I need your help!
Thanks.
J
You cannot use a Fixlet or Task or Relevance or Session Relevance to get this info.
Once a computer is removed it is no longer available this way.
The only way to get info on Removed/Deleted computers is to query the SQL DB directly for computers marked as deleted.
This thread might help - Query SQL database for deleted computers and who deleted them
I’ll have to dig through my documents for the SQL query. Ill update you, when i get time.
Many thanks, I so much appreciate any help. My first posting here shows that I’m going to love the support here!
There you go,
SELECT [ComputerID] ,[IsDeleted] FROM [BFEnterprise].[dbo].[COMPUTERS] where [IsDeleted] = 1
That should show the list of removed computers.