-
Posts
1949 -
Joined
-
Last visited
-
Days Won
93
Posts posted by GarthMJ
-
-
It looks like each fo those KB have been supereed. So there is no way to report on these details.
-
The last 4 itmes on this link plus the wiki note will solve this for you.
-
oooppps, Wrrong post. This one should get you started.. http://smsug.ca/blogs/garth_jones/archive/2008/08/14/add-date-filter-to-advert-status.aspx
-
-
-
This built-in report in CM07 or CM12 will give you these details.
-
Is this for SSRS or ASP reporting?
-
FYI This report should give you just about everything that you need.
http://smsug.ca/blogs/garth_jones/archive/2008/02/04/basic-all-in-one.aspx
-
No, That WQL view does not exist within CM12.
Try Configuration Item Compliance State instead.
-
I would recommend against adding MAC address (or IP address) to any report, as this will duplicate lines within the report and add (IMO) no value to the report.
Why do you need the MAC address?
-
-
it is not possible to do this..
-
Why not use the built-in feature within SSRS to do this? aka why re-invent the wheel?
-
The simple anwser is remove IP address from the report. I almost never use IP address within any or my reports because of this issue.
-
Is this CM07, CM12 or SMS2k3?
Are you talking about SSRS or ASP report?
-
So what was the query?
-
I’m not sure that I’m following you.
All you need to do is create the SQL query and then you can create the report either SSRS or ASP.
-
Try re-install the Reporting point.
-
The only way to solve this is to delete the status message from the database, there is no supported way to do this however all status message should be move after ~90 days.
-
Yes you can gather this information with CM07. You will need to edit the sms_def.mof to collect
AdminPasswordStatus from Win32_ComputerSystem

report for computers with multiple network adapers
in Reports
Posted
try this
http://smsug.ca/blogs/garth_jones/archive/2012/10/18/pc-by-gateway.aspx