Description: Retrieves a list of all programs installed by the Windows installer.
What The Data Shows: Curious if someone’s installed X program? Show any rogue programs running in the environment.
SQL:
SELECT name,version,install_location,install_date FROM programs WHERE name !="""";