Loading
search-img

Portal User asked a question.

August 28, 2019 at 7:00 AM
All Installed Software Report?
Anyone ever find a way to run a report of all installed software per computer? In the SLM under reports its too big and times out. I did add the column for Installed = Yes. I have also tried to break it down by regional reports. But that's a lot of boxes to check.  Is there a way to do this straight from SQL? Anyone have the SQL string for that? Other suggestions?  Thanks, 
  • 8 answers
  • 233 views

  • Jelle Wijndelts (Flexera Software)

    Hi Mark,  Have you tried running the report as a scheduled report? Normally when a report times out it is because the amount of data is too much for the browser to deal with. a scheduled report runs in the background and gets sent via email. Kind regards, Jelle

    • Portal User

      Well that's a darn good idea. I'll try that now. Thank you.

    • Portal User

      Looks like I will need to trim it down somehow. I get this error in the ReportExporter log: 2019-08-29 13:50:27,000 [113] INFO  SnowSoftware.LicenseManager.ReportExporterService.ScheduledExportManager [()] - Starting scheduled export. (ScheduleID: 5fe227f5-1964-4679-86a5-922b2b39e481) 2019-08-29 13:56:50,212 [113] ERROR SnowSoftware.LicenseManager.ReportExporterService.ScheduledExportManager [()] - Failed to export report. SnowSoftware.Exporting.ExportException: Could not export report. ---> System.ApplicationException: RowIndex: 1048576 ---> System.ArgumentException: Row or column index is invalid or out of required range.    at GemBox.Spreadsheet.CellRange.d(Int32 A_0, Int32 A_1)    at GemBox.Spreadsheet.CellRange.get_Item(Int32 relativeRow, Int32 relativeColumn)    at SnowSoftware.Exporting.Excel.ExcelExport.AddDataRows()    --- End of inner exception stack trace ---    at SnowSoftware.Exporting.Excel.ExcelExport.AddDataRows()    at SnowSoftware.Exporting.Excel.ExcelExport.ParseReport()    at SnowSoftware.Exporting.Excel.ExcelExport.Load(IExportInfo exportInfo, DataSet dataSet)    at SnowSoftware.Exporting.ExportFactory.Create(IExportInfo exportInfo, DataSet data, IIocResolver scope)    --- End of inner exception stack trace ---    at SnowSoftware.Exporting.ExportFactory.Create(IExportInfo exportInfo, DataSet data, IIocResolver scope)    at SnowSoftware.LicenseManager.ReportExporterService.ScheduledExportManager.<ExportAsync>d__23.MoveNext() 2019-08-29 13:56:50,227 [113] INFO  SnowSoftware.LicenseManager.ReportExporterService.ScheduledExportManager [()] - Finished scheduled export. Removed item from queue. (ExportID: 5fe227f5-1964-4679-86a5-922b2b39e481)
      Expand Post

      • Oliver Berger (Flexera Software)

        Hi ‌, not sure if the excel rowlimit is still hardcoded for all export types https://support.office.com/en-us/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3  . You could use a csv export for example (if not done yet). And SQL (assuming you are cid 1 and userid 1 exec stockreportfilespercomputer 1,1,' and ca.isinstalled = 1' you can get all the filters with  select r.name, rp.* from tblreport r left outer join tblReportParametersLink rpl on r.ReportID = rpl.ReportID left outer join tblReportParameters rp on rpl.ReportParameterID = rp.ID where r.name = 'Files per computer' You just need to add the BaseSql part, solving the {1}, to the @parameters parameter of the procedure. Than save the result to csv. But as said in the beginning - it is a excel row limit - you would't be able to open that file directly in excel. Maybe creating a cursor going thru all your organisationnodes and using BCP  https://docs.microsoft.com/en-us/sql/relational-databases/import-export/bulk-import-and-export-of-data-sql-server?view=sql-server-2017  you could create one resultfile  per organisational node. So maybe, time about thinking what you want to archive with this amount of data.  Well, hope that helps somehow. Cheers Oliver
        Expand Post

        • Portal User

          I had to break them up by region using the Criteria for Organization LIKE. It ran three separate reports. So I think I'm good. I remembered to save them for future use. Thanks all for the direction and help.  

          • RuthSam

            Hi Mark, Posted a query related to Oracle changes to Commercial Java SE model in the community but haven't heard from anyone. Thought I will run it with you.  We are currently having a SAM partner helping us with Oracle audit and we need to identify all the computers with a Software that is identified with Java and Open JDK on it. Following is an example of multiple Apache Applications which could be clubbed under Apache Software foundation.   Apache ActiveMQ (Linux) Apache Ant (Linux) Apache CXF (Linux) Apache Flex Apache HTTP Server Apache HTTP Server (Linux) Apache Kafka (Linux) Apache Lucene (Linux) Apache Maven (Linux) Apache Struts (Linux) Apache Tomcat Apache Tomcat (Linux)   Is there a way in SLM or SQL query to list all the Computers whose manufacturer is "Apache Software foundation". Since Snow deducts it as separate applications, I am not sure if this is even possible? Any other method that you can think of? Thank you in advance.
            Expand Post

          • RuthSam

            Hi Mark, Posted a query related to Oracle changes to Commercial Java SE model in the community but haven't heard from anyone. Thought I will run it with you.  We are currently having a SAM partner helping us with Oracle audit and we need to identify all the computers with a Software that is identified with Java and Open JDK on it. Following is an example of multiple Apache Applications which could be clubbed under Apache Software foundation.   Apache ActiveMQ (Linux) Apache Ant (Linux) Apache CXF (Linux) Apache Flex Apache HTTP Server Apache HTTP Server (Linux) Apache Kafka (Linux) Apache Lucene (Linux) Apache Maven (Linux) Apache Struts (Linux) Apache Tomcat Apache Tomcat (Linux)   Is there a way in SLM or SQL query to list all the Computers whose manufacturer is "Apache Software foundation". Since Snow deducts it as separate applications, I am not sure if this is even possible? Any other method that you can think of? Thank you in advance.
            Expand Post

    • Portal User

      Yes and no, if we trim it down it works but otherwise its too unwieldy and does not always work.  Trying again now.

+1.800.374.4353
CONTACT SALES SUPPORT HUB FLEXERA REVENERA
© 2026 Flexera. All rights reserved.
Privacy policy Terms and conditions Revenera Community Help
Loading
All Installed Software Report?