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 Comments • Jump to latest comment
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
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
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.
Would you like to reply?
Login or Register to post your comment.