Lansweeper logo
Home Download Features Demo Buy now Help Support forum
 
    Most requested support articles:
  Lansweeper troubleshooting guide.
  The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
  WMI Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
  How to configure the windows firewall using group policies.
  Support:  
 support@lansweeper.com  
Skype: Lansweeper  
  Mo-Fri 9h-17h CET  
Welcome Guest Search | Active Topics | Log In | Register

Tag as favorite
Report which would show hardware older than a specific date?
Options
Previous Topic Next Topic
dawnlowery
#1 Posted : Wednesday, August 18, 2010 7:16:42 PM

Rank: Premium user

Groups: Premium Users
Posts: 19
Location: US
I'm in need of a report that may not even be possible, but I thought I would ask.

I need a report that would provide a list of all workstations/laptops (and or servers) that are older than 4 years. I do not know if there is even a field or field(s) that could provide this info. I'm not too versed in sql so I thought I would post the question to the pros! If anyone already has a script I would be so greatful!
Back to top
Lansweeper
#2 Posted : Wednesday, August 18, 2010 7:41:08 PM

Rank: Administration

Groups: Administration, Premium Users
Posts: 10,370
If you don't reinstall windows you can use the "Installdate" field in table "tbloperatingsystem"
Back to top
dawnlowery
#3 Posted : Thursday, August 19, 2010 12:55:46 PM

Rank: Premium user

Groups: Premium Users
Posts: 19
Location: US
Great! Thanks so much!
Back to top
Users browsing this topic
Guest
Tag as favorite
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Contact: E-mail Lansweeper - Skype : Lansweeper
Copyright 2004 - 2011 © Hemoco bvba