3 Replies Latest reply on May 18, 2010 11:03 AM by zman

    Query XP workstations installed in the last six months

    mhutche Rookie

      I am looking to query machines that have been installed in the last 6 months.

       

      I want to use the install date under  O\S \ NT Info \ Install Date

       

      Is there any syntax i can use in the query to have it look at the last six months based on the current date.

       

      I found this article that does the same thing but the same query syntax wil not work

       

      GetDate()-180

       

      http://community.landesk.com/support/docs/DOC-5788