How to export list of Unassigned Inventoried Software?

PiotrBraun asked a question.

March 10, 2020 at 7:00 AM

Hi, does anyone know how to export list of Unassigned Inventoried Software? I am talking about option in SLM SMACC (Software recognition > application definition > Unassigned Inventoried Software).

Julien
6 years ago
Hi Piotr, This is how I do it: - select a uis - ctrl A (now you have selected all uis) - ctrl C (copy all selected uis to clipboard) - open Excel - and ctrl V (paste) the clipboard information into an Excel sheet Good luck! Julien
Expand Post
- PiotrBraun
  6 years ago
  Hi Julien, I did it but there were like 600k lines and it took 1h+ and our server was near death...
  Expand Post
Portal User
6 years ago
you can actually copy the table using ctrl+C and then paste it into a text file.. you can then import into excel... might take a while if it's a lot of applications though so it may be worth filtering it a little
Expand Post
AxelLa
6 years ago
If you need this more often, it could be worth creating a custom report in SLM that shows "Unassigned Inventoried Software" and use the export functionality there.
Expand Post
Laim McKenzie
6 years ago
You can also do this via SQL which is a lot faster than doing it via SMACC. USE SnowLicenseManager SELECT SU. Name, SU. Manufacturer, SU. Language, SU. Version, SU. OSType, SU. Executable, SU. ExecutablePath, SU. AddedDate FROM tblSoftwareCIDUnassigned C JOIN tblSoftware SU on C. SoftwareCheckSum = SU. SoftwareCheckSum‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍
Expand Post
- PiotrBraun
  6 years ago
  That's what I was looking for! But still there should be option in SMACC to export that. Anyway thanks.
  Expand Post
  - Laim McKenzie
    6 years ago
    I do agree with you on that, but from my experience - going via SQL directly is usually a lot faster
    Expand Post
- AxelLa
  6 years ago
  ... and just to complete it: To build a custom report from Laim's SQL query just put the query into another query that creates a report - like the one below. /edit: You can actually skip the two lines 'DECLARE @KeyFieldName' and 'DECLARE @RowTargetLink:', as there will be no application with that name. Usually this allows to click onto a row in the report and get to the details of the object. ----------------------------------------------------------------------------------------------------------------- DECLARE @NAME NVARCHAR(MAX) = 'Unassigned Inventoried Software' DECLARE @uid uniqueidentifier = (SELECT NEWID()) DECLARE @Description NVARCHAR(MAX) = 'This report shows the unassigned inventoried software as usually visible in the Snow Management and Configuration Center only' DECLARE @ColumnList NVARCHAR(MAX) = 'Name,Manufacturer,Language,Version,OSType,Executable,ExecutablePath,AddedDate' DECLARE @ColVis NVARCHAR(MAX) = '1,1,1,1,1,1,1,1' DECLARE @KeyFieldName NVARCHAR(MAX) = 'Name' DECLARE @RowTargetLink NVARCHAR(MAX) = 'Applications.aspx?name=' DELETE FROM tblReport WHERE Name = @NAME DECLARE @SQL NVARCHAR(MAX) = 'SELECT SU.Name, SU.Manufacturer, SU.Language, SU.Version, SU.OSType, SU.Executable, SU.ExecutablePath, SU.AddedDate FROM SnowLicenseManager.dbo.tblSoftwareCIDUnassigned C JOIN SnowLicenseManager.dbo.tblSoftware SU on C.SoftwareCheckSum = SU.SoftwareCheckSum' INSERT INTO tblReport (ReportID, StockReport, IsCustomReport, ReportType, ViewName, Name, Description, SQLQuery, ColumnList, ColumnVisibility, KeyFieldName, RowTargetLink, UsesCustomFields, CustomFieldCategoryID) VALUES (@uid, 0, 1, 3 , 'QUERYBUILDER', @NAME, @Description, @SQL, @ColumnList, @ColVis, @KeyFieldName, @RowTargetLink, 1, 1) INSERT INTO tblreportsecurity SELECT ReportID, 0 FROM tblReport WHERE ReportID = @uid
  Expand Post