Client Management Suite

 View Only
  • 1.  Database field - Software

    Posted Mar 28, 2011 03:22 AM

    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



  • 2.  RE: Database field - Software

    Posted Mar 28, 2011 10:03 AM

    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%'



  • 3.  RE: Database field - Software

    Posted Mar 28, 2011 10:14 AM

    Try to find into Item:

     

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


  • 4.  RE: Database field - Software

    Posted Apr 06, 2011 06:07 AM

    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



  • 5.  RE: Database field - Software

    Posted Apr 06, 2011 11:14 AM

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



  • 6.  RE: Database field - Software

    Posted Apr 07, 2011 08:31 AM

    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