Hi,
We are having agentless Vmware Inavtory based on API which pulls data from vCenters, apparently, there are number VM hosts we have seen which inventoried log back still those are present in All inventory. I have the below queries on that.
My thought is if we removing any Vcenter from the Inventory rule then related all hosts must have removed themselves automatically.
Your thoughts pls.
‎Dec 17, 2020 04:36 AM
Hi,
Please change the 90 days as needed. And please be aware what you're doing.
USE FNMSInventory
SELECT ir.ComputerID
INTO #Computer
FROM InventoryReport ir
WHERE DATEDIFF(DAY, COALESCE(SWDate,HWDate,VMWareServicesDate), GETDATE()) > 90
EXEC ComputerRemoveBatch
Best regards,
Markward
‎Dec 21, 2020 01:47 AM
Hi,
Well, the resulting inventory is not linked to your inventory rule. So, removing the vCenter shouldn't change anything.
Best regards,
Ma rkward
‎Dec 17, 2020 05:58 AM
‎Dec 18, 2020 03:07 AM
Hi,
Please change the 90 days as needed. And please be aware what you're doing.
USE FNMSInventory
SELECT ir.ComputerID
INTO #Computer
FROM InventoryReport ir
WHERE DATEDIFF(DAY, COALESCE(SWDate,HWDate,VMWareServicesDate), GETDATE()) > 90
EXEC ComputerRemoveBatch
Best regards,
Markward
‎Dec 21, 2020 01:47 AM