Client Management Suite

 View Only
  • 1.  Altiris 7.1 Find a specific file in managed computer

    Posted Mar 10, 2012 04:07 AM

    I am currently requested to find out all computers with the file test.xls saved in their computers.

    Is there a way for me to get this done in Altiris?

    Thanks.



  • 2.  RE: Altiris 7.1 Find a specific file in managed computer

    Posted Mar 10, 2012 09:15 AM

    Use this SQL to create a filter or a report.

     

    SELECT vc.Name AS [Computer]
          ,vc.[User] AS [Primary User]
          ,ifd.Name AS [File]
    FROM vComputer vc
    JOIN Inv_Installed_File_Details ifd
       ON ifd._ResourceGuid = vc.Guid
    JOIN Inv_File_Details fd
       ON fd._ResourceGuid = ifd.FileResourceGuid
    WHERE LOWER(ifd.Name) = 'text.xls'
    ORDER BY vc.Name


  • 3.  RE: Altiris 7.1 Find a specific file in managed computer

    Posted Mar 12, 2012 01:03 AM

    but what step should i take prior to create the SQL?



  • 4.  RE: Altiris 7.1 Find a specific file in managed computer
    Best Answer

    Posted Mar 12, 2012 07:50 PM

    Have you run Inventory on your clients?  Make sure you rollout the Inventory plug-in and then a full hardware/software inventory will ensue.  This should get you enough information in the database to get results back for that query.  Just go to Settings->Agents/plug-ins then under Discovery and Inventory to enable the Inventory plug-in Install policy.



  • 5.  RE: Altiris 7.1 Find a specific file in managed computer

    Broadcom Employee
    Posted Mar 13, 2012 05:30 AM

    For more details, please see the article "Installing the Inventory and Application Metering Plug-ins" at http://www.symantec.com/docs/HOWTO63526

    Predefined inventory policies "Collect Full Inventory" (and "Collect Full Server Inventory" if you use the product Inventory Pack for Servers) ...
    - are enabled by default
    - collect full inventory (hardware and operating system, software, and file properties inventory data),
    - run on all computers with the Inventory Plug-in (or Inventory Pack for Servers Plug-in) installed,
    - run ASAP after the first time installation,
    - run ASAP on any new computer that joins the target collection,
    - run on the defined schedule (Weekly, every Monday at 18:00 (6:00 P.M.))

    You can find additional information about predefined inventory policies at http://www.symantec.com/docs/HOWTO63549