Doing a big no-no, and trying to get an export from the database with a sql query for application inventory. I'm running the following:
select application_name,application_version, count(*) as count from applications group by application_name
is creating what appears to be a complete list of apps by version, however my count seems to be way off (by THOUSANDS in some cases). Anyone got a query that works for them to get an exportable application inventory? I've seen others working through this same problem (some mention the API, which I haven't had any luck with either) with mixed results. Any suggestions (other than don't play in the DB) will be greatly appreciated.
What I'm specifically after is our Adobe products (contract time!). I've seen others suggest using some form of
WHERE c.application_name LIKE '%
type statement to sort just the names you're after, but that's not working much for me either. In case you hadn't realized, I'm very much a SQL n00b.