Collection based off of Hardware inventory date

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

Collection based off of Hardware inventory date

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> Collection based off of Hardware inventory date

Page: [1]

Message

<< Older Topic Newer Topic >>

Collection based off of Hardware inventory date - 1/11/2005 9:23:12 AM

gdavies

Posts: 204
Score: 18
Joined: 10/18/2004
Status: offline

Guys,

Is there a way to create a dynamic collection based off of last hardware inventory date? I want a create a dynamic collection of all machines that have not run a hardware inventory in 45 days.

I can base the collection off of workstation status last hardware scan, but I need to set a hard date (ie: " 20041121" ) for the collection to work. Is there a way to set it to " Older than 45 days" anywhere else?

Thanks

< Message edited by gdavies -- 1/11/2005 9:27:30 AM >

_____________________________

Greg Davies
SMS/Citrix Engineer
MCSE, MCSA

Post #: 1

RE: Collection based off of Hardware inventory date - 1/11/2005 9:43:08 AM 1 votes

mcarriere893

Posts: 3621
Score: 300
Joined: 4/12/2002
From: Manitoba, Canada
Status: offline

See this old 2.0 article. Was written for hw inventory older than 14 days.

http://www.myitforum.com/articles/1/view.asp?id=5578

< Message edited by rodtrent -- 10/29/2008 6:26:09 AM >

_____________________________

Mark Carriere
Microsoft MVP-SMS
www.SMSUG.ca

(in reply to gdavies)

Post #: 2

RE: Collection based off of Hardware inventory date - 1/11/2005 10:02:01 AM

gdavies

Posts: 204
Score: 18
Joined: 10/18/2004
Status: offline

Perfect. Thanks!

_____________________________

Greg Davies
SMS/Citrix Engineer
MCSE, MCSA

(in reply to gdavies)

Post #: 3

RE: Collection based off of Hardware inventory date - 1/11/2005 10:52:18 AM

gdavies

Posts: 204
Score: 18
Joined: 10/18/2004
Status: offline

One more question for you Mark.....With this new lovely information you gave me, I changed my mind, I no longer want to make a collection but simply a stored procedure to automatically delete my old information.

Do you know exactly how the DATEDIFF function works? The article has the value set to >30 to get 14 day old machines. What would I set it to for 30 or 45 day old machines? I believe it may be a typo in the article and that it is set to 30 days, not 14.

< Message edited by gdavies -- 1/11/2005 10:55:37 AM >

_____________________________

Greg Davies
SMS/Citrix Engineer
MCSE, MCSA

(in reply to gdavies)

Post #: 4

RE: Collection based off of Hardware inventory date - 1/11/2005 1:12:08 PM

mcarriere893

Posts: 3621
Score: 300
Joined: 4/12/2002
From: Manitoba, Canada
Status: offline

You' re right (not my article), should be 14 for 14 days.

Datediff syntax is datdiff(interval, date1, date2), where the interval is set to day in the script.

_____________________________

Mark Carriere
Microsoft MVP-SMS
www.SMSUG.ca

(in reply to gdavies)

Post #: 5

RE: Collection based off of Hardware inventory date - 10/29/2008 5:14:05 AM

hbaron

Posts: 2
Score: 0
Joined: 6/4/2008
Status: offline

it seems that the link is dead, someone can tell me the new url if it have just moved ?

(in reply to mcarriere893)