Try identifying the software's that you want to monitor and create software metering Rule as suggested by above , once done ,you have default reports like Computers that have a metered program installed, but have not run the program since a specified date and reports as well under Category: Software Metering My Blog @ www.eskonr.com

Hi Team, i need to pull the list of installed softwares which are not used from last three months, can anyone please provide me the sql query.

The Software Metering enabled? You can get these list with Software metering.

You can use the Software Metering feature and the builtin reports to assist you with that. For more information about softwar emetering check - http://technet.microsoft.com/en-us/library/bb694169.aspx Kent Agerlund | My blogs: http://blog.coretech.dk/author/kea/ and http://scug.dk/ | Twitter @Agerlund | Linkedin: /kentagerlund