Client Management Suite

 View Only
Expand all | Collapse all

Undefined Software Report

  • 1.  Undefined Software Report

    Posted Jun 01, 2021 11:29 AM
    Hello,

    I have been tasked with cleaning up our undefined software catalog.  Before I start looking at each piece of software I was hoping to find a report that will give me a list of all software in the undefined folder along with how many computers it is installed on.  I am new to Symantec Client Management, and have looked through the prebuilt reports but don't see what I am looking for.  Did I miss the report I need or do I need to modify an existing report?  If I need to modify an existing report could you please include the report name and the modifications?  I am really bad at SQL.   

    Thank you for any and all help

    Kris


  • 2.  RE: Undefined Software Report

    Broadcom Employee
    Posted Jun 02, 2021 05:36 AM
    Hello, Kristopher!

    The "undefined software" folder keeps "software components" that are not associated with "software products" - these entities' major purpose is to track software usage and license usage of software (if defined).

    Placement of software in "undefined software"  folder or removal from it is an automated scheduled process tracking SW components-> products association by SW Product rules definition.

    Thus, the only way to move the SW component out of "undefined software" folder manually is to associate it manually with some product via "Manage this software"  action

    Or from the other end - create SW Product with a "Software definition" rule that would find all the related SW components and after "Create Software Product" wizard completion the component will disappear from the  "Undefined Software"


    As for the aggregate report "Installed on N computers" that shows Many components with the aggregate count - I believe there is no such.  
    One should check it component by component - like on the example below.



    In SQL - all the "software is installed" info is located in the table  Inv_InstalledSoftware.

    Please use the following SQL for the report you need :

    select si._SoftwareComponentGuid as [Guid], it.Name as [Software Name], count(*) as Count from Inv_InstalledSoftware si
    join vRM_Software_Component_Item it on si._SoftwareComponentGuid = it.Guid
    where si.InstallFlag=1
    group by (si._SoftwareComponentGuid), it.Name


    Hope this helps.
    Artur.



    ------------------------------
    Software Engineer 5
    Broadcom Inc.
    ------------------------------



  • 3.  RE: Undefined Software Report

    Posted 17 days ago

    Hello,

    I was reading this article and I was wandering if would be possible to remove the undefined software massively but follwoing some criteria.
    In our case, we dont know why, we can find more than 60.000 identical entries for MS Office in turkish (it does not make sense in our company). The ids are different, for xample:

    Displaying image.png
    Is there any way to make this cleansing?

    Thanks a lot in advance.




  • 4.  RE: Undefined Software Report

    Broadcom Employee
    Posted 17 days ago

    Hi Pablo !

    What is your ITMS version? 

    I cannot see the attached image from your post for some reason, but most probably  you came across is a well known problem with Turkish letter  ı https://stackoverflow.com/questions/52402151/how-to-uppercase-turkish-i


    which in the guts of ITMS code was causing creation of thousands of duplicate resources in the database in ITMS prior to 8.7 - typical use-case would be reporting software  inventory from machines where software with Turkish letter ı in the name was installed - then that piece of software would create a duplicate in ITMS DB.

    We fixed that problem in 8.7, so there will be no more NEW duplicates. However that fix would not remove the existing software components.

    1) If you are sure that  there are no associated policies or tasks to all those 60000 resources that you may just safely delete them all - just search them by name which is specific to your Turkish Software in the SW Catalog and apply "Delete" action on them. I would suggest to do it in chunks. 

    2) Create a Software Release like "My Well-Known Turkish Software Component" - or whatever you like, so that you will be able to find that one among all your software in the ITMS DB




    3) If your client machines still have Turkish MS Office they will continue sending it to NS with the software inventory.  To avoid creation of new resources:
    Create a "Known As" regex mapping containing part of name (not including the Turkish 'i' just in case) , so that any new software component resource arriving in an NSE would be mapped to ""My Well-Known Turkish Software Component"


    If everything goes well,  in the end there will remain  just 1  redundant component corresponding to MS Office Turkish that you created manually.

    If you do not succeed with the procedure above then please create a ticket via the support channel
    Regards
    Artur





    ------------------------------
    Software Engineer 5
    Broadcom Inc.
    ------------------------------



  • 5.  RE: Undefined Software Report

    Posted 17 days ago

    Hello Andrew,

    Thanks a lot for your answer. We are about to migrate to 8.7 but we need to upgrade first our NS from Server 2012 to Server 2019... hope it happens soon.

    Unfortunately, the turkish office was only n example. We have 198K rows in Software undefine and am pretty sure that we dont have any policy or such undefined software is not installed in any machine. We dont really know from where it has been imported... In any case, we would like to remove it because I think it will improve our performance.

    My question is, If I remove everything, the 198K products, the correct ones should be imported automatically, Am I right? Or not?

    Thanks for your support.

    example






  • 6.  RE: Undefined Software Report

    Broadcom Employee
    Posted 17 days ago

    Hello Pablo!

    From performance perspective you are correct - the less resources the better is SQL performance.

    The semantics of Software Catalog filters is defined here:

    It might be confusing unless you have experience with Product entities configuration in ITMS for license and usage tracking.
    "Undefined Software"  historically means "Some software which is not associated with any Software Product Resources" . The set MAY contain deliverable software as well, i.e potentially you may have assigned policies and tasks for several of those 198 K.

    However you may safely TRY to  delete everything - those having policies and tasks will fail to delete.

    >  My question is, If I remove everything, the 198K products, the correct ones should be imported automatically, Am I right? Or not?
    If you run software inventory on agents, then yes.  If there is at least 1 installation instance of that software on your client machines, these will be reported back again. But after the deletion you should run FULL software inventory, not delta - at least once. 

    You may check the source of software in this view:



    Regards
    Artur







    ------------------------------
    Software Engineer 5
    Broadcom Inc.
    ------------------------------



  • 7.  RE: Undefined Software Report

    Posted 17 days ago
    Thanks Arthur,

    Could you please let me know how could i delete all entries of Undefined
    software? From the filter i cannot select all in one shot as i meed to
    scroll down and load entries in sets of 100…

    Any clue here?

    Thanks a lot and your help is much appreciated!
    --
    Best Regards / Saludos
    ___________________________

    PABLO LLORENTE ABAD
    EMEA Workplace Services , Workplace Specialist

    Calle Albasanz 14, 4th floor
    Madrid , Spain
    Mobile +34 ​672746460
    *pablo.llorente@holcim.com


  • 8.  RE: Undefined Software Report

    Broadcom Employee
    Posted 17 days ago

    Hi Pablo!

    Try these steps  for selecting ALL 
    1) Select the 1st 
    2) Ctrl+ A

    By chunks:
    1) select 1st
    2) scroll down N screens
    3) Shift + mouse click  on any arbitrary

    Regards
    Artur



    ------------------------------
    Software Engineer 5
    Broadcom Inc.
    ------------------------------



  • 9.  RE: Undefined Software Report

    Posted 17 days ago
      |   view attached
    Hello Arthur,

    Selecting 1st and Control + A, I select the 100 rows that have been loaded
    in the screen, so I need to scroll down and load another 100, and then
    another 100... so If I want to select 198.000 rows I need to scroll down
    1980 times... Do you know what I mean?

    Whenever I load 100 new entries, it takes around 10 seconds... Is there any
    way to use the database and remove everything from there?



    Thanks!

    Best Regards / Saludos
    ___________________________

    PABLO LLORENTE ABAD
    EMEA Workplace Services , Workplace Specialist

    Calle Albasanz 14, 4th floor
    Madrid , Spain
    Mobile +34 672746460
    *pablo.llorente@holcim.com


  • 10.  RE: Undefined Software Report

    Broadcom Employee
    Posted 17 days ago

    Hello Pablo!

    Running SQL directly for items deletion is forbidden, because with probability of 99.9% it will leave the DB corrupted.

    This method should work:
    1) select 1st
    2) scroll down till the bottomn end 
    3) Shift + mouse click  on the last one 

    I have several hundreds in the list, all of these were selected this way.
    Still I would recommend to delete couple of thousands first -  this will give you approximate understanding how long it will take to delete everything 


    Regards
    Artur 



    ------------------------------
    Software Engineer 5
    Broadcom Inc.
    ------------------------------



  • 11.  RE: Undefined Software Report

    Posted 17 days ago
    HEllo Arthur,

    Whenever I scroll down trying to reach the latest one, I go antil line 100,
    and another 100 are loaded, then I go until the End and I reach row 200,
    and I load again etc etc. I cannot go to the 198.000 line directly...

    Lets attach a video.





    Best Regards / Saludos
    ___________________________

    PABLO LLORENTE ABAD
    EMEA Workplace Services , Workplace Specialist

    Calle Albasanz 14, 4th floor
    Madrid , Spain
    Mobile +34 672746460
    *pablo.llorente@holcim.com


  • 12.  RE: Undefined Software Report

    Broadcom Employee
    Posted 17 days ago
      |   view attached

    Hello Pablo!

    Here is a custom report where is same SQL query used to show all same "Undefined Software Component" list as it is shown on ITMS views page.
    Open report, type in search field what is required to delete > +Shift multi-select and scroll down > right click > delete

    Download attached "Undefined Software Components.xml"  and import it
    Best regards,
    IP.


    Attachment(s)



  • 13.  RE: Undefined Software Report

    Posted 17 days ago
    Yeeeees!!!

    Super Thanks Igor!!!!

    Best Regards / Saludos
    ___________________________

    PABLO LLORENTE ABAD
    EMEA Workplace Services , Workplace Specialist

    Calle Albasanz 14, 4th floor
    Madrid , Spain
    Mobile +34 672746460
    *pablo.llorente@holcim.com


  • 14.  RE: Undefined Software Report

    Posted 14 days ago

    Hi,

    to cleanup unwanted software that will reappear after deletion I create some "collector" products. 

    These software products filter out drivers, etc. After creating the product I switch it to unmanaged. They run in the background and filter drivers, etc.