Video Screencast Help

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

luke.s's picture

Try to find into Item:

 

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

If the suggestion has helped to solve your problem, please mark the post as a solution.

Fábio Sanches
IT Technical Manager | WTR Services | www.wtrservices.com.br

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