All Installed Software Report?

Portal User asked a question.

August 28, 2019 at 7:00 AM

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,

Jelle Wijndelts (Flexera Software)
7 years ago
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
Expand Post
- Portal User
  7 years ago
  Well that's a darn good idea. I'll try that now. Thank you.
  Expand Post
- Portal User
  7 years ago
  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)
    7 years ago
    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
    7 years ago
    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.
    Expand Post
    RuthSam
    7 years ago
    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
    7 years ago
    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
  7 years ago
  Yes and no, if we trim it down it works but otherwise its too unwieldy and does not always work. Trying again now.
  Expand Post