Video Screencast Help
Search Video Help Close Back
to help

Need a report to show Vcenter data/file

Created: 06 Aug 2012 | 4 comments
adude's picture
adude Accredited Certified
0 0 Votes
Login to vote

I have NS6 R13 with CMS/SMS. I have been asked to produce a report to show all computers that have the VMware Virtual Center Server executable. One of the files is named "vpxd.exe"  This is one of the files the auditors are looking for. As you can see in the attached pic the file appears  under the Aex AC NT Services table. but I've tried countless time to build a simple report with the search criteriea for "vpxd" or "VMware VirtualCenter Server" or the path using the listed table from the db but it will not output the service. The report will work for other services such as VSS if search that instead of vpxd. Is there something different about this service? the server "VCENTER" is a Windows Server 2003.

 

Thank you

Andre

Discussion Filed Under:
, , ,

Comments 4 Comments • Jump to latest comment

KSchroeder's picture
KSchroeder Trusted Advisor Certified
Need a report to show Vcenter data/file - Comment:07 Aug 2012 : Link
select vc.Name, vc.[OS Name], nt.Name AS [Service], nt.Description, nt.Path as [Service Path], nt.StartupType, nt.LogonAs AS [Credentials], nt.Version
FROM vComputer vc
JOIN Inv_AeX_AC_NT_Services nt ON vc.Guid = nt._ResourceGuid
WHERE nt.Path LIKE '%vpxd.exe%'



Thanks,
Kyle
Symantec Trusted Advisor

For Forum threads, please click "Mark as Solution" if answered.
For all content, please give a thumbs up if you agree with or support the post.

0
Login to vote
  • Actions
adude's picture
adude Accredited Certified
Need a report to show Vcenter data/file - Comment:07 Aug 2012 : Link

That get me in the right direction.

Thank you!

Andres Ochoa

Altiris Certifed Engineer CMS II 6.5

Symantec Certified Specialist CMS 7.1

0
Login to vote
  • Actions
KSchroeder's picture
KSchroeder Trusted Advisor Certified
Need a report to show Vcenter data/file - Comment:08 Aug 2012 : Link

Glad to help Andres. Could you click the "Mark as solution" link on my comment to resolve the thread?
Thanks!

Thanks,
Kyle
Symantec Trusted Advisor

For Forum threads, please click "Mark as Solution" if answered.
For all content, please give a thumbs up if you agree with or support the post.

0
Login to vote
  • Actions
adude's picture
adude Accredited Certified
Need a report to show Vcenter data/file - Comment:08 Aug 2012 : Link

Well yesterday I got another glitch in this report for  VMware. I can open the resource manager for the server "vcenter", and look at the "Aex OS Add Remove Programs" table and see several VMware Programs listed and that is correct on the server add/remove programs. However, If I try to build a custom report using the same "Aex OS Add Remove Programs" table with the search criteria ofl [Aex OS Add Remove Programs][Publisher] [like] "vmware%" I get mostly correct data, yet the server "vcenter" does not appear in the reported data. I see other servers with the same VMware programs listed but not 'vcenter"

If I run other canned Add/Remove Program reports vcenter appears in some but not all. Am I missing something? BTW: I made sure that I ran Full Recreate Inventory & Software Inventory Monday and yesterday.

Andres Ochoa

Altiris Certifed Engineer CMS II 6.5

Symantec Certified Specialist CMS 7.1

0
Login to vote
  • Actions