Tag: query

SQL Query to find duplicate rows

I needed a SQL query that would parse through hundreds of thousands of records and list duplicate content. I found a SQL query that would work and made my own modifications to it so that the query may return the desired results. This is one of those things I will not remember so here is the script. SELECT emailaddress, firstname,…

Read More »

Query Adobe Acrobat 7.x using LANDesk

Some environments need to report on installed Adobe Acrobat 7.x using LANDesk Software License Monitoring. Querying on the main executable, ACROBAT.EXE, does not produce reliable results because the file size remains the same across multiple 7.x releases. As a result, version-based queries against the executable are inconclusive. The supporting library ACROBAT.DLL, however, changes between versions and can be used instead….

Read More »