Video Screencast Help

RESOURCEGUID TO MACHINE NAME

Created: 18 May 2011 | 3 comments

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 ?

Comments 3 CommentsJump to latest comment

Andrew Bosch's picture

http://localhost/Altiris/Console/Dashboard/Dashboa...

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

------------------------------------
Sr. Principal SQA Engineer
Symantec

mclemson's picture

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?

Mike Clemson, Senior Systems Engineer, ASC
Intuitive Technology Group -- Symantec Platinum Partner
intuitivetech.com

jharings's picture

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.

Jim Harings
HP Enterprise Services
1st Rule of Connect Club: Mark the post that helped you the most as a 'solution'. 2nd Rule of Connect Club:You must talk about Connect club.