Video Screencast Help


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


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

Sr. Principal SQA Engineer

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

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.