As far as I'm aware, the Inventory Category property is not included in the reconciliation procedures and can be changed while the reconciliation operation is still in progress.
I set up a daily job to update the Inventory device category with below mentioned SQL query that lookup the device operating system and then update its category desktop/server accordingly. However I noticed that in the database categories are being updated in the [ComplianceComputer_MT] table but no change/visible in the All Inventory view, strange! but the following day it is visible in the
Does anyone know why that is happening whereas earlier same query works without any issue?
--update category for clinets
UPDATE [FNMP].[dbo].[ComplianceComputer_MT]
SET [CategoryID] = '4.-1.-1.-4.'
WHERE CategoryID IS NULL AND( [OperatingSystem] LIKE '%Windows 10%'
OR [OperatingSystem] LIKE '%Windows 7%'
OR [OperatingSystem] LIKE '%Windows 8.1%'
OR [OperatingSystem] LIKE '%Windows Embedded%'
OR [OperatingSystem] LIKE '%Windows XP%'
OR [OperatingSystem] LIKE '%Windows version 6.2%'
OR [OperatingSystem] LIKE '%Windows 11%')
--update category for servers
UPDATE [FNMP].[dbo].[ComplianceComputer_MT]
SET [CategoryID] = '4.-1.-1.-1.'
WHERE [CategoryID] IS NULL AND (
[OperatingSystem] LIKE '%AIX%'
OR [OperatingSystem] LIKE '%CentOS%'
OR [OperatingSystem] LIKE '%Debian%'
OR [OperatingSystem] LIKE '%EulerOS%'
OR [OperatingSystem] LIKE '%HP_UX%'
OR [OperatingSystem] LIKE '%Linux%'
OR [OperatingSystem] LIKE '%Server%'
OR [OperatingSystem] LIKE '%OneView%'
OR [OperatingSystem] LIKE '%OpenSUSE%'
OR [OperatingSystem] LIKE '%Solaris%'
OR [OperatingSystem] LIKE '%Red Hat%'
OR [OperatingSystem] LIKE '%RedHat%'
OR [OperatingSystem] LIKE '%RedHatEnterprise%'
OR [OperatingSystem] LIKE '%SLES%'
OR [OperatingSystem] LIKE '%SunOS%'
OR [OperatingSystem] LIKE '%Ubuntu%'
OR [OperatingSystem] LIKE '%Vmware%'
OR [OperatingSystem] LIKE '%Windows 2000%'
OR [OperatingSystem] LIKE '%Windows 2003%')
Thanks
