Symantec Management Platform (Notification Server)

 View Only

  • 1.  Software Inventory Tables

    Posted Mar 19, 2012 02:02 PM

    Does anyone know which tables replaced 'dbo.cmn_sw_common' and 'inv_aex_sw_audit_software_spt' for SMP 7.1?

     

    Appreciate any help.



  • 2.  RE: Software Inventory Tables

    Posted Mar 19, 2012 06:22 PM

    Use Inv_InstalledSoftware.  It contains all installed software for Windows, Linux, UNIX, and Mac OS X platforms.  Inv_AddRemoveProgram is also used, but is Windows only.  It does help identify applications that are "Hidden" in Add/Remove Programs so we typically LEFT JOIN to get that information (if it exists).



  • 3.  RE: Software Inventory Tables

    Posted Mar 20, 2012 08:30 AM

    I did try that orginally but it is not providing the data I need. I am looking to get information on the .dll files in the system32 folder on Windows.

     

    I appreciate your quick reply though.



  • 4.  RE: Software Inventory Tables

    Posted Mar 20, 2012 01:23 PM

    Unless Inv_Installed_File_Details has what you want, I think you might need custom inventory to gather this info...



  • 5.  RE: Software Inventory Tables

    Posted Mar 27, 2012 08:47 AM

    I agree with Andrew, this sounds like a custom inventory.  Did you find a way to inventory those system32 .dll's?



  • 6.  RE: Software Inventory Tables

    Posted Aug 24, 2012 09:05 AM

    I tried this and it seems that this table references non windows items.. like wordpad, notepad.. i did those to test...

    since this is my dev server I do not have the one particular software I need installed on any of my test machines. Just installed it though...

    software is called medusa... well it isnt found after running an inventory..

     

    so aonyone have any update on how one could do this?

    i see a reference to a custom inventory.. that is new to me too so if I had to go that route..can someone point me in the right direction on how to do that?

     

    Thanks!

     



  • 7.  RE: Software Inventory Tables

    Posted Aug 24, 2012 09:18 AM
      |   view attached

    i posted this in a different topic but maybe it will help here too..

     

     

    i did however run this sql..
     
    select *
     
    From Inv_Installed_File_Details t0
    Where t0.Name like '%medus%'
     
     
    and it did not return anything...
     
    so I installed Medusa on a machine....
    then ran an inventory task.. just a plane software and file properties boxes are checked...
     
    it finished but didnt seem to have what i wanted... 
     
    so waited till now to run the code again... (about 15minutes)
     
     
     
     
     
     
     
    Looks like it DOES work.. but only for INSTALLED programs?????
     
    notepad, wordpad and the OS related stuff dont seem to show up...
     
    just wanted to put this if it helps someone else...