What is the SQL query I can use to determine how many unmanaged computers there are?
ITMS 7.x, 8.x
If a computer becomes unmanaged on a Child SMP Server, and you are using Inventory Forwarding, then that computer will show as unmanaged on the parent SMP Server as well.
Use this SQL for a report:
SELECT vi.name as 'Computer Name', v.ismanaged, v.guid,
vi.createddate as 'Created Date', vi.modifieddate as 'Modified Date'
FROM vresource v
JOIN vitem vi on vi.guid = v.guid
where v.ismanaged=0
AND v.resourcetypeguid = '493435F7-3B17-4C4C-B07F-C23E7AB7781F'
order by vi.modifieddate desc