Client Management Suite

 View Only

  • 1.  SQL Query to get all active software

    Posted Mar 12, 2018 12:00 PM

    Hi,

     

    I'm looking for a SQL query to get all the active software, asset name, No of Licenses, purchase Date and Enda date.



  • 2.  RE: SQL Query to get all active software

    Posted Mar 14, 2018 05:04 AM

    What is classed as Active, running on a machine in a given time period? 

    Where can I find the available Software License count in Asset Management?
    https://support.symantec.com/en_US/article.HOWTO98430.html

    ---

    TeleFragger wrote an Article that could be of use,

    Application Count and Machines Installed On - 3 reports
    https://www.symantec.com/connect/articles/application-count-and-machines-installed-3-reports



  • 3.  RE: SQL Query to get all active software

    Posted Mar 14, 2018 11:36 AM

    Yes, what are the softwares running on a machines now.

    I'm able to grab the data in bits and pieces but when I'm trying to join using the guids, I'm loosing some data and numbers doesn't match. It make me to think am I joining with the right Guid.

    Let me try with the articles you provided and see if that is going to help me.