Export Unassigned Inventoried Software list

Loading

Morgado asked a question.

January 9, 2019 at 8:00 AM

Export Unassigned Inventoried Software list

Hello,

Is it possible to export from SMACC / Software Recognition tab the list of Unassigned Inventoried Software?

I am looking to a list that has over 1.5B rows so it's very difficult to find something as the page becomes unresponsive.

I don't see a button for that. In case there isnt at all, would be possible to get this list with an SQL query?

Thanks,

Morgado

Community Manager (Flexera Software)
8 years ago
Hi Goncalo, for me it works to click in the list, hit CTRL+A, hit CTRL+C, switch to an xls sheet, hit CTRL+V and all lines get copied. /marcel
Expand Post
- Morgado
  8 years ago
  Hi there ‌ There is any other way? When I do ctrl+a the SMACC crashes :\ Thanks.
  Expand Post
- Morgado
  8 years ago
  Yes, i've noticed that a few minutes ago. Thanks.
  Expand Post
Morgado
8 years ago
Any other solution to extract this list? Maybe with a SQL query? Thanks.
Expand Post
- Community Manager (Flexera Software)
  8 years ago
  Hi Goncalo, please excuse the long wait. I was on a long business trip. select s. * from snowlicensemanager. dbo. tblSoftware s inner join snowlicensemanager. dbo. tblSoftwareCIDUnassigned su on s. SoftwareCheckSum = su. SoftwareCheckSum where s. IsHidden = 0 ‍ ‍ ‍ This is what you are searching for. /marcel
  Expand Post

Related Product Forums

→ Flexera One

→ FlexNet Manager

→ Snow License Manager

Need help finding an answer?

Ask a Question →

Loading

Export Unassigned Inventoried Software list