Identifying unmanaged computers are there attached to the SMP Server
search cancel

Identifying unmanaged computers are there attached to the SMP Server

book

Article ID: 181529

calendar_today

Updated On:

Products

IT Management Suite

Issue/Introduction

What is the SQL query I can use to determine how many unmanaged computers there are?

Environment

ITMS 7.x, 8.x

Resolution

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