Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

Database field - Software

Created: 28 Mar 2011 • Updated: 10 May 2011 | 5 comments
DekiD's picture

Hi folks

Ive got a short question. Can anyone explain me where I can find the following field in the Symantec_CMDB (marked with a red box / "add description) ??

In which table I can find this entry? Im using CMS 7.1.

THX!

Regards,

Deki

Comments 5 CommentsJump to latest comment

mclemson's picture

I'm not sure where it's stored, but I'd just dive into vItem.

In SQL Studio: SELECT Name, Description FROM vItem WHERE Name LIKE '%Reader%'

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

fabio.sanches's picture

Try to find into Item:

SELECT [Guid]
      ,[Name]
      ,[Description]
  FROM [Symantec_CMDB].[dbo].[Item]
  WHERE Item.Name LIKE '%Reader%'
DekiD's picture

Thank you very much guys!

Which tables I have to join if I would like to find out where this software component is installed? The Database schema for the 7.1 is showing me only the tables without any connections?! I should now which which tables I have to join together?

http://www.symantec.com/business/support/index?page=content&id=DOC3724&key=55274&actp=LIST

Regadrs,

Deki

mclemson's picture

Right-click on the software and choose Actions > Installed Software Report.  Does this get you what you need?  This is under Manage > Software.

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

DekiD's picture

thk u mclemson!

but ive resolved my query ;) Ive copied the installed sofware report by computer and joined the vItem table with the desc. field of the SW component.

Have a nice day!

Regards,

Deki