Symantec Management Platform (Notification Server)

Hello All.

I had a query and if you can please help me with the solution. I want a list of all offline machines which are there in our network but are not reporting in HW asset report (in Reports >> Discovery and inventory >> Inventory >> Hardware  >> Hardware inventory search report). Is there a way to get this information?

Reason being, this report only reports those machines which are live and running at that point of time. If I shutdown the machine, it doesn't appears in this report. I will like a mechanism to either retain all the machines from disappearing or if I can get list of all resources which are offline or didn't report when a HW report is fetched.

Thanks again.

Regards.

hmm interesting.. I dont see anything looking for a live machine...

here is the sql on that report:

DECLARE @v1_TrusteeScope nvarchar(max)
SET @v1_TrusteeScope = N'%TrusteeScope%'
SELECT DISTINCT i.Guid,
i.Name [Computer Name],
i.Domain [Domain],
cs.[Identifying Number] [Serial Number],
be.[Identification Code] [Asset Tag],
cs.Manufacturer [System Manufacturer],
cs.Model [Computer Model],
i.[System Type] [Computer Type],
d.[Unique ID] [UUID],
CASE WHEN be._ResourceGuid IS NOT NULL THEN 'ENABLED' ELSE 'DISABLED' END [SMBIOS Enabled],
ltrim(rtrim(str([SMBIOS Major Version])))  + '.' + ltrim(rtrim(str([SMBIOS Minor Version])))[SMBIOS Version],
'ENABLED' [DMI Enabled],
'' [DMI Version]
FROM dbo.vComputer i
JOIN dbo.ScopeMembership sm
    ON sm.[ResourceGuid] = i.Guid
    AND sm.[ScopeCollectionGuid] IN (SELECT * FROM dbo.fnGetTrusteeScopeCollections (@v1_TrusteeScope)) 
LEFT JOIN dbo.Inv_AeX_AC_Identification d
    ON d._ResourceGuid = i.Guid
JOIN dbo.vHWComputerSystem cs
    ON i.Guid = cs._ResourceGuid
LEFT JOIN dbo.vSWBIOSElement be
    ON be._ResourceGuid = i.Guid
LEFT JOIN dbo.vSWSMBIOSElement sbe
    ON sbe._ResourceGuid = i.Guid
WHERE i.Name LIKE '%Computer Name%'
AND cs.Manufacturer LIKE '%Manufacturer%'
AND cs.Model LIKE '%Model%'
AND i.[System Type] LIKE '%Computer Type%'

side note.. you could just do a check against client date... here is a sample of a quick check on machines not checking in for 5 or more days..

SELECT *
FROM [Inv_AeX_AC_Identification] T0
WHERE datediff(dd,T0.[Client Date],getdate()) > 5

order by T0.[Client Date] desc

Hi TeleFragger.

Thank you for your response and helping me immediately.

I have this query and yes I really don't see anything which says to only pick live machine but when I extract the report from HW inventory it is 500 odds whereas we have 600 odd machines. I know inventory agent is sitting on these machine and the moment I turn them in the network they will start appearing. I just need a way to understand which of them didn't appeared in that report or a total list of all offline+online reported in this report.

Your second query is probably coming from Inventory Diagnostics report. I have checked that too but it only reports machines which are not checked in last n number of days. In my case that may not necessary means that the machine is not in the report. I have a machine in HW report which appears in this report too and the last inventory check was in 2011. :)

Still looking for solution.

Regards,
Satyendra