Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > Head Count
User Name
REGISTER NOW! Mark Forums Read

sponsored links

1 8th March 23:05
External User
Posts: 1
Default Head Count

All, I have an SMS 2.0 site (hopefully this is the newsgroup for it) and I
am trying to get a count on machines that have been recently logged into
within the last 6 months. Could someone point me in the right direction?
Maybe a T-SQL statement or a custom report? Query?

Please help.

  Reply With Quote

  sponsored links

2 8th March 23:05
richard threlkeld
External User
Posts: 1
Default Head Count

If you want systems that people are actually logging onto with user accounts
you'll need to enable Win32_NetworkLogonProfile in your SMS_DEF.MOF or
create a custom tool on systems to track logons and report back to SMS and
then base your inventory off of that.

You'll also need to make sure that your Site Maintinence tasks are set to
more than 6 months so that the older inventory has not been removed from the
database. By default they are at 90 days which would need to have been
increased 6 months ago with what you are looking to do.

Richard Threlkeld
Microsoft MVP - SMS
  Reply With Quote

Thread Tools
Display Modes

Copyright 2006 - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -