Sherry Kissinger at myITforum.com - All Comments

re: Report on all members of all Local Groups

skissinger — Mon, 17 Oct 2011 12:37:28 GMT

By request, a report for 'members of the local Administrators group for a specific computer'

select lgm.name0 [Name of the Local Group]

,lgm.Account0 [Account]

,lgm.Category0 [Category of Account]

,lgm.Domain0 [Domain for the Account]

,lgm.Type0 [Type of Account]

from v_gs_localGroupMembers0 lgm

join v_r_system sys1 on sys1.resourceid=lgm.resourceid

where lgm.name0 = 'Administrators'

and sys1.Netbios_Name0 = @ComputerName

re: How to gather Monitor Information like Serial Number

skissinger — Wed, 12 Oct 2011 23:10:46 GMT

Since this blog article, there's also Roger Zanders' MonitorDetails WMI provider: sourceforge.net/.../wmimonitor

re: Script to set ConfigMgr Client's 'Install required updates on a schedule'

rtruss — Fri, 12 Nov 2010 17:27:50 GMT

Came across this looking for a subselect query to weed out clients with a specific app guid. Have you gotten any further on this? Is it working? We have thought about doing this same thing now that we are implimenting sccm.

re: Report on all members of all Local Groups

MeenEnta — Tue, 04 May 2010 14:18:56 GMT

Thank you Sherry for this, worked perfectly.

fast and accurate.

Best regards

George.

re: Report on Local Administrators Group membership - updated

kingskawn — Fri, 26 Feb 2010 08:31:48 GMT

Sherry,

I've added the correct lines to sms_def.mof but when I look at the views I can't find anything that begins with dbo.v_GS_localAdmins.

The steps I took are, I first added the few lines to sms_def.mof, then I tried to make the collection query but it gave me an error just as neil.frawley has.

I also executed the Localadmin.vbs on 2 clients to see if they give the correct data but I can't see any change.

Can you please advise on this?

Thanks ;-)

re: iPhone Inventory - Apps installed, last backup date, Version

skissinger — Tue, 09 Feb 2010 13:40:46 GMT

Those are SRS reports (SQL Reporting Services), the site role you can install when you have the R2 bits for ConfigMgr 2007. And... by the way... vNext will only have SRS. So if you don't have SRS installed, I encourage you to install it, and begin learning.

re: iPhone Inventory - Apps installed, last backup date, Version

kingskawn — Thu, 28 Jan 2010 16:33:24 GMT

What application do you use for reporting?

re: Report on Local Administrators Group membership - updated

skissinger — Mon, 25 Jan 2010 14:58:09 GMT

Neil: have you confirmed the data in inventoryagent.log, and see it in Resource Explorer on a test client? If not, then there's a disconnect. If you do, then it could be as simple as your environment didn't call the custom view v_gs_localAdmins, but instead called it v_gs_localadmins0, or v_gs_localadmins00. Try that, or launch SQL Management Studio and look at the views of your database, and see what it might be called. If that wasn't it, please post in the forums, I'll catch you there.

re: Report on Local Administrators Group membership - updated

neil.frawley — Sun, 24 Jan 2010 23:33:30 GMT

I have followed the instructions to the letter but the database view or table does not seem to be created. I am running SCCM 2007 R2 SP2.

When I run the report I get the following error, please help because I am really stuck and I'm not sure what else to try.

An error occurred when the report was run. The details are as follows:

Invalid object name 'v_GS_LocalAdmins'.

Error Number: -2147217865

Source: Microsoft OLE DB Provider for SQL Server

Native Error: 208

re: Mini Monster Mof builder updated to 1.10

scassells — Mon, 14 Dec 2009 22:36:11 GMT

Hi Sherry,

I found a typo in the DotNETFramework Reporting Class.

First pragma namespace is missing the # at the beginning.

#pragma namespace("\\\\.\\root\\cimv2\\sms")

#pragma deleteclass("DotNETFrameworks", NOFAIL)

re: Report on Local Administrators Group membership - updated

skissinger — Thu, 03 Dec 2009 17:21:19 GMT

In reply to diaz101, we're working through this in this thread: social.technet.microsoft.com/.../f153939b-88ac-4047-b50f-c0aa50537a17

re: Report on Local Administrators Group membership - updated

diaz101 — Wed, 02 Dec 2009 14:51:25 GMT

I have amended the MOF file on the SMS server with

[ SMS_Report (TRUE),SMS_Group_Name ("LocalAdmins"),SMS_Class_ID ("MICROSOFT|LocalAdmins|1.0")]

class Win32_LocalAdmins : SMS_Class_Template

{

[SMS_Report(TRUE), key] string AccountName;

[SMS_Report(TRUE), key] string GroupName;

};

and it has automatically compiled OK, I then compiled it on my local test machine (XP), ran the VBS script and a hardware inventory on the XP machine.

I still cannot find the SMS_G_System_LOCALADMINS table in the SMS database yet.

Have I done anything wrong???

thanks for your help

re: Report on Local Administrators Group membership - updated

Tom_Watson — Thu, 26 Nov 2009 11:36:49 GMT

I've updated the script to get non English Administrators. See www.myitforum.com/.../tm.htm

re: Roger Zanders' SCCM Client Center Updates

StephenCWLL — Tue, 06 Oct 2009 14:23:02 GMT

Ahh, thanks! Option One doesn't work for me. It just runs the new version and doesn't install it. It was smsclictr.sourceforge.net/update that I was looking for :) I had the link saved once but lost it :) Thanks!

re: Remote Regedit - Roger Zander Client Center

skissinger — Tue, 06 Oct 2009 14:15:23 GMT

StephenCWLL, where to get updates: myitforum.com/.../roger-zanders-sccm-client-center-updates.aspx