
RenanHammo asked a question.
Hi Flexerans,
Is there any way to export a sort of report of "View All Items" results under Catalog Items? I have about 4000 items and need to export them to csv , for example.

RenanHammo asked a question.
Hi Flexerans,
Is there any way to export a sort of report of "View All Items" results under Catalog Items? I have about 4000 items and need to export them to csv , for example.

There is no way to export "view all items". With that being said, it would be easy enough to run a query and export the results. The following query will give you more or less what you see under view all catalog items. You can always add more columns as necessary.
select PackageID, PackageTitle,
Case Type WHEN '1' THEN 'General' WHEN '15' THEN 'Application' WHEN '0' THEN 'Package' WHEN '0' THEN 'Package' WHEN '25' THEN 'JAMF' WHEN '28' THEN 'Intune' WHEN '4' THEN 'Task Sequence'END AS PackageType,
CreatedOn, FUID as Licensed,
Case PackageVisible WHEN '0' THEN 'False' WHEN '1' THEN 'True' END AS enabled,
Case PackageRequest WHEN '0' THEN 'False' WHEN '1' THEN 'True' END AS Approval
from WD_WebPackages
Note that I was a little lazy when it came to the packageType column.. There are a couple of less common packageTypes that I did not handle ion the Case.

→ Flexera One
→ Snow Atlas
→ FlexNet Manager
→ App Broker
Need help finding an answer?
There is no way to export "view all items". With that being said, it would be easy enough to run a query and export the results. The following query will give you more or less what you see under view all catalog items. You can always add more columns as necessary.
select PackageID, PackageTitle,
Case Type WHEN '1' THEN 'General' WHEN '15' THEN 'Application' WHEN '0' THEN 'Package' WHEN '0' THEN 'Package' WHEN '25' THEN 'JAMF' WHEN '28' THEN 'Intune' WHEN '4' THEN 'Task Sequence'END AS PackageType,
CreatedOn, FUID as Licensed,
Case PackageVisible WHEN '0' THEN 'False' WHEN '1' THEN 'True' END AS enabled,
Case PackageRequest WHEN '0' THEN 'False' WHEN '1' THEN 'True' END AS Approval
from WD_WebPackagesNote that I was a little lazy when it came to the packageType column.. There are a couple of less common packageTypes that I did not handle ion the Case.