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. source Even though…

Read More »

Query Adobe Acrobat 7.x using LANDesk

Adobe Acrobat 7 cannot be queried as ACROBAT.EXE as the file size remains the same. The results will be inconclusive. ACROBAT.DLL, however, changes. Update the LDAppl3.Template file to add .DLL to ScanExtentions. Go to LANDesk Management Suite, Software License Monitoring, and Make Available to Clients. To create the query use: “Computer”.”Software”.”Package”.”File Name” = “ACROBAT.DLL” Add a column using “Computer”.”Software”.”Package”.”Version”

Read More »