Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Saved query

Status
Not open for further replies.

GSC

MIS
Mar 27, 2001
464
EU
Hi,
I need to create a query that will show me:
From AD Users and Computers the Object tab - Modified Date.
I need the computers where this date is two months or older. Any help with the saved query is greatly appreciated.

Thanks in advance.
GSC
 
I guess you will need to run a loop on the ModifyTimeStamp variable, take the 1st 8 chrs YYYYMMDD ;-)

_________________________________
IBM CP, MCP 2000, E60 driver ;-)
 
I'm not quite sure how to set the saved query, do you have an example?

Thanks.
GSC
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top