Symantec Management Platform (Notification Server)

I'm trying to troubleshoot overlicensing issues and need to find the machine name or IP address of Windows machines from the respective ResourceGuid. Anyone got SQL query I can use please ?

http://localhost/Altiris/Console/Dashboard/DashboardView.aspx?ResourceGuid=8ab5fda8-10ab-4675-9ff2-e86c76a1ccc2

Obviously, just replace the ResourceGuid with the one for which machine details are needed.

I'm not sure what your ResourceGuid source is -- but it sounds like you know it and wrote it down or something.

If that's true you'd use a query like this:

SELECT Guid, Name, Domain, [OS Name], [IP Address] , [MAC Address], [System Type]

FROM vComputer

WHERE Guid='12345A6B-CDE7-8FG9-0A12-345BCD67EFG8'

Replacing the GUID in the query with whatever GUID you have from your source.

Does this answer your question?

You could create a parameter out of the guid string to resuse is %Guid% or have a where Guid in 'xxx,xxxx' so you could provide a list of guids. Either of the methods listed above should get what you need.