Symantec Management Platform (Notification Server)

 View Only
  • 1.  Custom Report CMS 7

    Posted Nov 30, 2010 10:23 AM

     

    Good morning,
     
     
     
    I have to create my first custom report to know how many PC in my domain 
    have a certain type of file in the disk c: in a particular location.
     
    I don't know SQL .
     
    Could someone help me?
     
    Is there a best practice to build custom report?
     
    Thank you in advance.


  • 2.  RE: Custom Report CMS 7

    Posted Dec 01, 2010 08:51 AM

    There are a couple of videos here on Connect, Endpoint Mgmt, Videos by Steven Riley, (search on "Reporting") that I've used to get started with custom reports.



  • 3.  RE: Custom Report CMS 7

    Posted Dec 02, 2010 06:45 AM

    You could use a SQL report like in the example below:

     

    --------------------------------------------------------------------------------------------------------------

    select VCOM.[Guid], VCOM.[Name] 'Computername', IIFD.[Name] 'Filename', IIFD.[Path] 'Filepath' from Inv_Installed_File_Details AS IIFD

    join vComputer AS VCOM

    on IIFD.[_ResourceGuid] = VCOM.[Guid]

    where IIFD.[Name] LIKE 'winword.exe'

    and IIFD.[Path] LIKE 'C:\Program Files\%'

    -------------------------------------------------------------------------------

     

    if its another file extension you need the make changes in Inventory Solution to include the file extension.