18 February 2010
For inboxes information to export to excel for single system complete list
sStartPath = "\\your sccmservername\SMS_smssitecode\inboxes\"
Set oFSO = CreateObject("Scripting.FileSystemObject")
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
objExcel.Workbooks.Add
intRow = 2
objExcel.Cells(1, 1).Value = "Directory"
objExcel.Cells(1, 2).Value = "Count"
ListFolders(sStartPath)
Sub ListFolders(sPath)
Set oFolder = oFSO.GetFolder(sPath)
objExcel.Cells(intRow, 1).Value = oFolder.Path
objExcel.Cells(intRow, 2).Value = oFolder.Files.Count
intRow = intRow + 1
For Each oFldr In oFolder.SubFolders
ListFolders oFldr.Path
Next
End Sub
Set sStartPath = Nothing
Set objExcel = Nothing
objExcel.Range("A1:B1").Select
objExcel.Selection.Interior.ColorIndex = 19
objExcel.Selection.Font.ColorIndex = 11
objExcel.Selection.Font.Bold = True
objExcel.Cells.EntireColumn.AutoFit
For inboxes information to export to excel for single system complete list
sStartPath = "\\your sccmservername\SMS_smssitecode\inboxes\"
Set oFSO = CreateObject("Scripting.FileSystemObject")
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
objExcel.Workbooks.Add
intRow = 2
objExcel.Cells(1, 1).Value = "Directory"
objExcel.Cells(1, 2).Value = "Count"
ListFolders(sStartPath)
Sub ListFolders(sPath)
Set oFolder = oFSO.GetFolder(sPath)
objExcel.Cells(intRow, 1).Value = oFolder.Path
objExcel.Cells(intRow, 2).Value = oFolder.Files.Count
intRow = intRow + 1
For Each oFldr In oFolder.SubFolders
ListFolders oFldr.Path
Next
End Sub
Set sStartPath = Nothing
Set objExcel = Nothing
objExcel.Range("A1:B1").Select
objExcel.Selection.Interior.ColorIndex = 19
objExcel.Selection.Font.ColorIndex = 11
objExcel.Selection.Font.Bold = True
objExcel.Cells.EntireColumn.AutoFit
Delete script for bad inboxes files for SMS / SCCM
DEL /Q \\MYSCCMSERVERNAME\sms_sitecode\inboxes\auth\dataldr.box\bad
DEL /Q \\MYSCCMSERVERNAME\sms_sitecode\inboxes\auth\ddm.box\BAD_DDRS
DEL /Q \\MYSCCMSERVERNAME\sms_sitecode\inboxes\auth\ddm.box\bad
DEL /Q \\MYSCCMSERVERNAME\sms_sitecode\inboxes\ddm.box\BAD_DDRS
DEL /Q \\MYSCCMSERVERNAME\sms_sitecode\inboxes\auth\statesys.box\corrupt
-------------------
Thanks,
Jonathan Swift - "May you live every day of your life."
Delete script for bad inboxes files for SMS / SCCM
DEL /Q \\MYSCCMSERVERNAME\sms_sitecode\inboxes\auth\dataldr.box\bad
DEL /Q \\MYSCCMSERVERNAME\sms_sitecode\inboxes\auth\ddm.box\BAD_DDRS
DEL /Q \\MYSCCMSERVERNAME\sms_sitecode\inboxes\auth\ddm.box\bad
DEL /Q \\MYSCCMSERVERNAME\sms_sitecode\inboxes\ddm.box\BAD_DDRS
DEL /Q \\MYSCCMSERVERNAME\sms_sitecode\inboxes\auth\statesys.box\corrupt
-------------------
Thanks,
Jonathan Swift - "May you live every day of your life."
FOR INBOXES SCRIPT DEVELOPED BY me...
ECHO dc1 >>"D:\SCCM Team\Daily_checks_archive_Reports\INBOXES\BACKLOGS.txt"
diruse /* /m "\\MYSCCMSERVERNAME\d$\Program Files (x86)\Microsoft Configuration Manager\inboxes" >>"D:\SCCM Team\Daily_checks_archive_Reports\INBOXES\BACKLOGS.txt"
date /t >>"D:\SCCM Team\Daily_checks_archive_Reports\INBOXES\BACKLOGS.txt"
ECHO P01 >>"D:\SCCM Team\Daily_checks_archive_Reports\INBOXES\BACKLOGS.txt"
diruse /* /m "\\MYSCCMSERVERNAME2\d$\Program Files (x86)\Microsoft Configuration Manager\inboxes" >>"D:\SCCM Team\Daily_checks_archive_Reports\INBOXES\BACKLOGS.txt"
ECHO P02 >>"D:\SCCM Team\Daily_checks_archive_Reports\INBOXES\BACKLOGS.txt"
diruse /* /m "\\MYSCCMSERVERNAME3\d$\Program Files (x86)\Microsoft Configuration Manager\inboxes" >>"D:\SCCM Team\Daily_checks_archive_Reports\INBOXES\BACKLOGS.txt"
ECHO P03 >>"D:\SCCM Team\Daily_checks_archive_Reports\INBOXES\BACKLOGS.txt"
diruse /* /m "\\MYSCCMSERVERNAME4\d$\Program Files (x86)\Microsoft Configuration Manager\inboxes" >>"D:\SCCM Team\Daily_checks_archive_Reports\INBOXES\BACKLOGS.txt"
date /t >>"D:\SCCM Team\Daily_checks_archive_Reports\INBOXES\BACKLOGS.txt"
ECHO P04 >>"D:\SCCM Team\Daily_checks_archive_Reports\INBOXES\BACKLOGS.txt"
diruse /* /m "\\MYSCCMSERVERNAME5\d$\Program Files (x86)\Microsoft Configuration Manager\inboxes" >>"D:\SCCM Team\Daily_checks_archive_Reports\INBOXES\BACKLOGS.txt"
-------------------
Thanks,
Pablo Picasso - "Computers are useless. They can only give you answers."
FOR INBOXES SCRIPT DEVELOPED BY me...
ECHO dc1 >>"D:\SCCM Team\Daily_checks_archive_Reports\INBOXES\BACKLOGS.txt"
diruse /* /m "\\MYSCCMSERVERNAME\d$\Program Files (x86)\Microsoft Configuration Manager\inboxes" >>"D:\SCCM Team\Daily_checks_archive_Reports\INBOXES\BACKLOGS.txt"
date /t >>"D:\SCCM Team\Daily_checks_archive_Reports\INBOXES\BACKLOGS.txt"
ECHO P01 >>"D:\SCCM Team\Daily_checks_archive_Reports\INBOXES\BACKLOGS.txt"
diruse /* /m "\\MYSCCMSERVERNAME2\d$\Program Files (x86)\Microsoft Configuration Manager\inboxes" >>"D:\SCCM Team\Daily_checks_archive_Reports\INBOXES\BACKLOGS.txt"
ECHO P02 >>"D:\SCCM Team\Daily_checks_archive_Reports\INBOXES\BACKLOGS.txt"
diruse /* /m "\\MYSCCMSERVERNAME3\d$\Program Files (x86)\Microsoft Configuration Manager\inboxes" >>"D:\SCCM Team\Daily_checks_archive_Reports\INBOXES\BACKLOGS.txt"
ECHO P03 >>"D:\SCCM Team\Daily_checks_archive_Reports\INBOXES\BACKLOGS.txt"
diruse /* /m "\\MYSCCMSERVERNAME4\d$\Program Files (x86)\Microsoft Configuration Manager\inboxes" >>"D:\SCCM Team\Daily_checks_archive_Reports\INBOXES\BACKLOGS.txt"
date /t >>"D:\SCCM Team\Daily_checks_archive_Reports\INBOXES\BACKLOGS.txt"
ECHO P04 >>"D:\SCCM Team\Daily_checks_archive_Reports\INBOXES\BACKLOGS.txt"
diruse /* /m "\\MYSCCMSERVERNAME5\d$\Program Files (x86)\Microsoft Configuration Manager\inboxes" >>"D:\SCCM Team\Daily_checks_archive_Reports\INBOXES\BACKLOGS.txt"
-------------------
Thanks,
Pablo Picasso - "Computers are useless. They can only give you answers."
For Windows 2003 Server Event viewer archive script
ServerName = "."
Set FSO = CreateObject("Scripting.FileSystemObject")
StartTime = Now
Output "---------------------------------"
OutPut "Started at: " & CStr(Now)
Output ""
Set System = GetObject("winmgmts:{(Backup,Security)}\\" & ServerName & _
"\root\CIMV2")
If Err.Number = 0 Then
Set colLogs = System.ExecQuery("select * from Win32_NTEventLogFile",,48)
LogName = ServerName& "_" & LogFileName(refLog.LogFileName) & _
"_" & DateString
FSO.DeleteFile(strArchiveFolder & "\" & LogName & ".evt")
If Purge Then
RetVal = reflog.ClearEventlog(strArchiveFolder & "\" & LogName & ".evt")
Else
RetVal = reflog.BackupEventlog(strArchiveFolder & "\" & LogName & ".evt")
End If
If RetVal = 0 Then
Output vbTab & "Log was archived in .evt format: " & LogName & ".evt"
If Purge Then Output vbTab & "All events were cleared from the log"
Else
Output vbTab & "Error while archiving in .evt format."
End If
Next
Else
Output vbTab & "Failed connect to the server"
End If
Set colLogs = Nothing
Set refLogs = Nothing
Set System = Nothing
OutPut "Finished at: " & CStr(Now)
Output ""
Output ""
Set WS = Nothing
' FullLog.Close ???FullLog=unknown
Set FullLog = Nothing
Set FSO = Nothing
Today = Date
If Month(Today) < 10 Then
CurrentDate = "0" & CStr(Month(Today))
Else
CurrentDate = CStr(Month(Today))
End If
If Day(Today) < 10 Then
CurrentDate = CurrentDate & "0" & CStr(Day(Today))
Else
CurrentDate = CurrentDate & CStr(Day(Today))
End If
CurrentDate = CurrentDate & CStr(Year(Today))
If Hour(Time) < 10 Then
CurrentDate = CurrentDate & "0" & CStr(Hour(Time))
Else
CurrentDate = CurrentDate & CStr(Hour(Time))
End If
End Function
Select Case LogName
Case "Application"
LogFileName = "app"
Case "Directory Service"
LogFileName = "dir"
Case "DNS Server"
LogFileName = "dns"
Case "File Replication Service"
LogFileName = "rep"
Case "Security"
LogFileName = "sec"
Case "System"
LogFileName = "sys"
End Select
End Function
' wscript.echo text
' FullLog.writeline text ???FullLog=unknown
End Sub
-------------------
Thanks,
Mike Ditka - "If God had wanted man to play soccer, he wouldn't have given us arms."
For Windows 2003 Server Event viewer archive script
ServerName = "."
Set FSO = CreateObject("Scripting.FileSystemObject")
StartTime = Now
Output "---------------------------------"
OutPut "Started at: " & CStr(Now)
Output ""
Set System = GetObject("winmgmts:{(Backup,Security)}\\" & ServerName & _
"\root\CIMV2")
If Err.Number = 0 Then
Set colLogs = System.ExecQuery("select * from Win32_NTEventLogFile",,48)
LogName = ServerName& "_" & LogFileName(refLog.LogFileName) & _
"_" & DateString
FSO.DeleteFile(strArchiveFolder & "\" & LogName & ".evt")
If Purge Then
RetVal = reflog.ClearEventlog(strArchiveFolder & "\" & LogName & ".evt")
Else
RetVal = reflog.BackupEventlog(strArchiveFolder & "\" & LogName & ".evt")
End If
If RetVal = 0 Then
Output vbTab & "Log was archived in .evt format: " & LogName & ".evt"
If Purge Then Output vbTab & "All events were cleared from the log"
Else
Output vbTab & "Error while archiving in .evt format."
End If
Next
Else
Output vbTab & "Failed connect to the server"
End If
Set colLogs = Nothing
Set refLogs = Nothing
Set System = Nothing
OutPut "Finished at: " & CStr(Now)
Output ""
Output ""
Set WS = Nothing
' FullLog.Close ???FullLog=unknown
Set FullLog = Nothing
Set FSO = Nothing
Today = Date
If Month(Today) < 10 Then
CurrentDate = "0" & CStr(Month(Today))
Else
CurrentDate = CStr(Month(Today))
End If
If Day(Today) < 10 Then
CurrentDate = CurrentDate & "0" & CStr(Day(Today))
Else
CurrentDate = CurrentDate & CStr(Day(Today))
End If
CurrentDate = CurrentDate & CStr(Year(Today))
If Hour(Time) < 10 Then
CurrentDate = CurrentDate & "0" & CStr(Hour(Time))
Else
CurrentDate = CurrentDate & CStr(Hour(Time))
End If
End Function
Select Case LogName
Case "Application"
LogFileName = "app"
Case "Directory Service"
LogFileName = "dir"
Case "DNS Server"
LogFileName = "dns"
Case "File Replication Service"
LogFileName = "rep"
Case "Security"
LogFileName = "sec"
Case "System"
LogFileName = "sys"
End Select
End Function
' wscript.echo text
' FullLog.writeline text ???FullLog=unknown
End Sub
-------------------
Thanks,
Mike Ditka - "If God had wanted man to play soccer, he wouldn't have given us arms."
17 February 2010
Tool to create MOF file
Mark Cochrane (System Center Configuration Manager MVP) released an excellent tool to assist with your custom MOF snippet creations, RegkeyToMof. Grab it from here: http://www.myitforum.com/inc/upload/12336RegKeyToMOF.zip
To use it, Run regkeytomof on a box which has the regkeys you want to gather, and browse in the top window to the Regkey Location, until you see the keys & values you want on the right. Then below in the middle-right, give it a ClassGroup (like CUSTOM) and a ClassName (this must be unique for each custom mof edit you do--but the ClassGroup of CUSTOM can always be CUSTOM) then just copy & paste the results for configuration mof & sms_def.mof
If there are values that you don't want to see in your database, before you save sms_def.mof, just change those from TRUE to FALSE. (Leave them defined, but change to FALSE, it needs to be consistent)
For example, I've been meaning to make up a Microsoft Forefront client mof edit, similar to the ones available for McAfee and Symantec, for client AV signature info. Mark's tool made it much easier. If you look at the below screenshot, I just browsed until I found the regkeys I wanted (in Software\Microsoft\Microsoft Forefront\Client Security\1.0\AM\Signature Updates. On the right, I could see there were entries for AVSignatureVersion and ASSignatureVersion. Looks like just what I wanted!
In the middle, I changed the Classgroup to CUSTOM. I always use CUSTOM for my custom edits. That helps me to differentiate anything I've done from a 'real' mof snippet from Microsoft. If you like, you could use any name; but I would keep it short and consistent, and no spaces. i.e., if you work for ACME Corporation, use something like ACMECorp. For ClassName, this must be unique for each custom edit you make. For example, let's say that one day there will be a Microsoft Forefront version 2.0, and that clients' info goes into a completely different area of the registry. But for a time, I might need to gather both 1.0 keys and 2.0 keys. So I couldn't call both of the ClassNames "MSForefront". That's why in my sample I called it MSForefront1, anticipating that one day there will be a MSForeFront2 I'll want to have. Also, for the ClassName, no spaces. And don't use _ i.e., don't use MS_ForeFront_1.0. I think you *can* use them, but in some places within your database tables/views, you might end up with double _; that just feels messy to me. So avoid the whole thing and don't use spaces or underscores. AND keep it short.
So, cool; I've got my edits. I'm using Configuration Manager, so I need the results from the SCCM Configuration.mof and SCCM sms_def.mof. Now, to check them. Hm... do I really need AVSignatureApplied? I could, I suppose.. but if I *do* want them, if I actually go look at the registry, those binary values are multi binary, not just 1 entry for binary of 0 vs 1. It's hard to programmatically see that with regkeytomof, so it's not already set to be multi; but if I DID want to gather that info, I just need to add the [] to those entries. But actually... those values don't really mean much to me. They aren't in any kind of calendar date format that makes sense to me. So I would likely just change those from TRUE to FALSE anyway. So I'd end up with this. And it only took me about 10 minutes to get that edit together, and make decisions about TRUE vs. FALSE. Easy!
// configuration.mof for MS Forefront 1.0 Client Signatures
#pragma namespace ("\\\\.\\root\\cimv2")
#pragma deleteclass("MSForeFront1", NOFAIL)
[DYNPROPS]
Class MSForeFront1
{
[key] string KeyName;
String EngineVersion;
String AVSignatureVersion;
String ASSignatureVersion;
Boolean ASSignatureApplied[];
Boolean AVSignatureApplied[];
String SignatureLocation;
};
[DYNPROPS]
Instance of MSForeFront1
{
keyname="SystemCenter.fr";
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Microsoft Forefront\\Client Security\\1.0\\AM\\Signature Updates|EngineVersion"),Dynamic,Provider("RegPropProv")] EngineVersion;
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Microsoft Forefront\\Client Security\\1.0\\AM\\Signature Updates|AVSignatureVersion"),Dynamic,Provider("RegPropProv")] AVSignatureVersion;
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Microsoft Forefront\\Client Security\\1.0\\AM\\Signature Updates|ASSignatureVersion"),Dynamic,Provider("RegPropProv")] ASSignatureVersion;
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Microsoft Forefront\\Client Security\\1.0\\AM\\Signature Updates|ASSignatureApplied"),Dynamic,Provider("RegPropProv")] ASSignatureApplied;
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Microsoft Forefront\\Client Security\\1.0\\AM\\Signature Updates|AVSignatureApplied"),Dynamic,Provider("RegPropProv")] AVSignatureApplied;
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Microsoft Forefront\\Client Security\\1.0\\AM\\Signature Updates|SignatureLocation"),Dynamic,Provider("RegPropProv")] SignatureLocation;
};
//sms_def.mof for MS Forefront 1.0 Client Signatures
#pragma namespace ("\\\\.\\root\\cimv2\\SMS")
#pragma deleteclass("MSForeFront1", NOFAIL)
[SMS_Report(TRUE),SMS_Group_Name("MSForeFront1"),SMS_Class_ID("CUSTOM|MSForeFront1|1.0")]
Class MSForeFront1: SMS_Class_Template
{
[SMS_Report(TRUE),key] string KeyName;
[SMS_Report(TRUE)] String EngineVersion;
[SMS_Report(TRUE)] String AVSignatureVersion;
[SMS_Report(TRUE)] String ASSignatureVersion;
[SMS_Report(FALSE)] Boolean ASSignatureApplied[];
[SMS_Report(FALSE)] Boolean AVSignatureApplied[];
[SMS_Report(FALSE)] String SignatureLocation;
};
--
----------------
Thanks
----------------
Tool to create MOF file
Mark Cochrane (System Center Configuration Manager MVP) released an excellent tool to assist with your custom MOF snippet creations, RegkeyToMof. Grab it from here: http://www.myitforum.com/inc/upload/12336RegKeyToMOF.zip
To use it, Run regkeytomof on a box which has the regkeys you want to gather, and browse in the top window to the Regkey Location, until you see the keys & values you want on the right. Then below in the middle-right, give it a ClassGroup (like CUSTOM) and a ClassName (this must be unique for each custom mof edit you do--but the ClassGroup of CUSTOM can always be CUSTOM) then just copy & paste the results for configuration mof & sms_def.mof
If there are values that you don't want to see in your database, before you save sms_def.mof, just change those from TRUE to FALSE. (Leave them defined, but change to FALSE, it needs to be consistent)
For example, I've been meaning to make up a Microsoft Forefront client mof edit, similar to the ones available for McAfee and Symantec, for client AV signature info. Mark's tool made it much easier. If you look at the below screenshot, I just browsed until I found the regkeys I wanted (in Software\Microsoft\Microsoft Forefront\Client Security\1.0\AM\Signature Updates. On the right, I could see there were entries for AVSignatureVersion and ASSignatureVersion. Looks like just what I wanted!
In the middle, I changed the Classgroup to CUSTOM. I always use CUSTOM for my custom edits. That helps me to differentiate anything I've done from a 'real' mof snippet from Microsoft. If you like, you could use any name; but I would keep it short and consistent, and no spaces. i.e., if you work for ACME Corporation, use something like ACMECorp. For ClassName, this must be unique for each custom edit you make. For example, let's say that one day there will be a Microsoft Forefront version 2.0, and that clients' info goes into a completely different area of the registry. But for a time, I might need to gather both 1.0 keys and 2.0 keys. So I couldn't call both of the ClassNames "MSForefront". That's why in my sample I called it MSForefront1, anticipating that one day there will be a MSForeFront2 I'll want to have. Also, for the ClassName, no spaces. And don't use _ i.e., don't use MS_ForeFront_1.0. I think you *can* use them, but in some places within your database tables/views, you might end up with double _; that just feels messy to me. So avoid the whole thing and don't use spaces or underscores. AND keep it short.
So, cool; I've got my edits. I'm using Configuration Manager, so I need the results from the SCCM Configuration.mof and SCCM sms_def.mof. Now, to check them. Hm... do I really need AVSignatureApplied? I could, I suppose.. but if I *do* want them, if I actually go look at the registry, those binary values are multi binary, not just 1 entry for binary of 0 vs 1. It's hard to programmatically see that with regkeytomof, so it's not already set to be multi; but if I DID want to gather that info, I just need to add the [] to those entries. But actually... those values don't really mean much to me. They aren't in any kind of calendar date format that makes sense to me. So I would likely just change those from TRUE to FALSE anyway. So I'd end up with this. And it only took me about 10 minutes to get that edit together, and make decisions about TRUE vs. FALSE. Easy!
// configuration.mof for MS Forefront 1.0 Client Signatures
#pragma namespace ("\\\\.\\root\\cimv2")
#pragma deleteclass("MSForeFront1", NOFAIL)
[DYNPROPS]
Class MSForeFront1
{
[key] string KeyName;
String EngineVersion;
String AVSignatureVersion;
String ASSignatureVersion;
Boolean ASSignatureApplied[];
Boolean AVSignatureApplied[];
String SignatureLocation;
};
[DYNPROPS]
Instance of MSForeFront1
{
keyname="SystemCenter.fr";
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Microsoft Forefront\\Client Security\\1.0\\AM\\Signature Updates|EngineVersion"),Dynamic,Provider("RegPropProv")] EngineVersion;
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Microsoft Forefront\\Client Security\\1.0\\AM\\Signature Updates|AVSignatureVersion"),Dynamic,Provider("RegPropProv")] AVSignatureVersion;
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Microsoft Forefront\\Client Security\\1.0\\AM\\Signature Updates|ASSignatureVersion"),Dynamic,Provider("RegPropProv")] ASSignatureVersion;
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Microsoft Forefront\\Client Security\\1.0\\AM\\Signature Updates|ASSignatureApplied"),Dynamic,Provider("RegPropProv")] ASSignatureApplied;
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Microsoft Forefront\\Client Security\\1.0\\AM\\Signature Updates|AVSignatureApplied"),Dynamic,Provider("RegPropProv")] AVSignatureApplied;
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Microsoft Forefront\\Client Security\\1.0\\AM\\Signature Updates|SignatureLocation"),Dynamic,Provider("RegPropProv")] SignatureLocation;
};
//sms_def.mof for MS Forefront 1.0 Client Signatures
#pragma namespace ("\\\\.\\root\\cimv2\\SMS")
#pragma deleteclass("MSForeFront1", NOFAIL)
[SMS_Report(TRUE),SMS_Group_Name("MSForeFront1"),SMS_Class_ID("CUSTOM|MSForeFront1|1.0")]
Class MSForeFront1: SMS_Class_Template
{
[SMS_Report(TRUE),key] string KeyName;
[SMS_Report(TRUE)] String EngineVersion;
[SMS_Report(TRUE)] String AVSignatureVersion;
[SMS_Report(TRUE)] String ASSignatureVersion;
[SMS_Report(FALSE)] Boolean ASSignatureApplied[];
[SMS_Report(FALSE)] Boolean AVSignatureApplied[];
[SMS_Report(FALSE)] String SignatureLocation;
};
--
----------------
Thanks
----------------
Tools and Utilities for ConfigMgr / SCCM 2007 Including beta's
- SCCM OU Collection Creator - Matthew Hudson
===Tools and Utilities===
- SccmAutoDoc Kim Oppalfens, who is a SCCM MVP, has released a neat utility called SccmAutoDoc. SccmAutoDoc is a command line utility that automatically documents an SCCM site into a human-readable form with minimal user input. Only the useful information is included, as opposed to items that are largely used internally.
- SMSNotify SMSNotify, by myITforum member Dan Thompson, presents the user with an informative screen that lets them know a package will install at a scheduled time and allows the user to postpone the installation for a future time. Many, many other features and options.
- ConfigMgr / SCCM / SMS Documentation Script v1.18 This vbs script will create detailed documentation for your ConfigMgr / SCCM / SMS server.
- ENGL Zwlancfg - ENGL. ENGL Zwlancfg is a tool that simplifies the unattended deployment of Microsoft wireless network settings to Windows XP and Vista machines. Profiles can be created, deleted, exported and imported. Zwlancfg can be run from the command line or from the Microsoft System Center Configuration Manager (SCCM) Task Sequence Plugin.
- ConfigMgr Branch DP Add - ddelgado1 on CodePlex. BDPAdd is a tool that will bulk add protected branch distribution points to a ConfigMgr 2007 (SCCM) hierarchy. There is currently not a way, in the ConfigMgr console, to add multiple protected Branch distribution points at once. This tools attempts to address that problem. (Note: The tool could be easily modified, if needed, to add unprotected branch DPs. I needed protected Branch DPs though, so that's what I wrote this for.
- ConfigMgr Site Bound Tool - ddelgado1 on CodePlex. SiteBound is a tool that allows bulk addition of boundaries to ConfigMgr (SCCM ) sites. Adding boundaries through the ConfigMgr console can be tedious if adding more than a handful. Previously for SMS 2003 there was the Siteboun.exe tool which solved this problem, however, to my knowledge there is not a version of this tool available for ConfigMgr 2007. If there is, then oh well I still learned something.
- Coretech SCCM Manager - Freeware- Coretech A/S
Formerly known as "Coretech Application Creator for SCCM" This utility is developed based on many years of experience with Microsoft System Management Server now System Center Configuration Manager. Our mission is to streamline every aspect of the package creation process thus making the daily administration of the system smarter. In the latest version you'll also find functionality to prestage computers and configure variables used in the image deployment process.
- ConfigMgr MP Policy Checker - Vincent Dipippo - I have written a tool that will allow you to select a policy and then check that policy via HTTP pulls to all of the MPs. The tool is multi-threaded for performance and works well in large environment.
- 1E Migration Tool - This tool is designed to allow an SMS Administrator to Migrate all or selected packages and programs from his SMS environment into a System Center Configuration Management (ConfigMgr) environment. The tool has the following features: The Migration of Package and Program details along with source files; Renaming of Package and Program names during migration; Direct transfer of packages from your SMS site to ConfigMgr; Export to flat file structure from SMS site and Import into ConfigMgr from flat file; Exporting of SMSNomad command line settings to new ConfigMgr Nomad tab settings.
- ConfigMgr Collection Query Rule Embedded Reference Checker - The tool enumerates all existing site codes, collections, and query rules on that server. It then uses regular expressions to detect probable collection references (i.e. any site code followed by 5 hex digits). There is also a special case for the built-in collections, which do not correspond to a site code (starting instead with SMS) and do not conform to the strict standard for user-created collections (e.g. SMSDM001, SMS000GS, etc.) Finally, it cross-references those collection IDs to the actual list of collections and includes them by ID and name for review. Any collection ID that is found in a rule but not in the collections enumerated from the server is reported as "**** Unknown ****". You can search the output for this to identify bad references.
- ConfigMgr Package Distribution Health Browser - While the console is quite functional in checking the distribution status of packages in general, I wrote a tool that helps administrators zero in on package replication issues much more quickly. First, it accesses the associated views in the database directly, which makes it much faster to get at this information than the console, which is a front-end to the ConfigMgr WMI provider. Second, it offers some sorting and filtering options that highlight the replication issues much more efficiently than reviewing the total status for every package individually.
- SCCM Client Center 2.0 or SCCM Client Center 2.0 by Roger Zander
- Wiki Documentation Documentation for SCCM Client Center 2.0
- Updates to MSI Updates when using MSI to install
- 1E's Service Window Provides a graphical interface that allows an administrative user to view, add, edit and delete maintenance windows (service windows) on a selected target computer. Maintenance windows define times during which Microsoft System Center Configuration Manager 2007(ConfigMgr) can apply advertisements and software update deployments to the specified computer. If no windows are specified then the computer can receive advertisements at any time. Administrators may assign advertisements outside any maintenance windows irrespective of what has been set.
- Collection Commander 1.3.1 by Roger Zander
Initiate SMS 2003 advanced client actions on a collection: Ping,WakeUp,HW/SW Inventory,ReRun Advertisements,Show logged on user,Download/Refresh Policy,Repair SMS Agents,Import Clients to the Collection.
- Web Remote Tools by Ron Crumbaker
-- Modifications and Additions to Web Remote Tools 3.21
- SCCM Right Click Tools by rhouchins
- SMS Server Tools 0 2 2 - By Bernard White
Suite of 7 tools including: 1. Management Point Ping (mpping.exe), 2. Site Information (siteinfo.exe), 3. Package Information (pkginfo.exe), 4. Distribution Point Mod (dpmod.exe), 5. Site Control File Check (scfcheck.exe), 6. Site Services (sitesvc.exe), 7. Collection Membership (cmember.exe). For more info see: http://netplantation.com
- SMS SCCMTroubleShooter by Greg Ramsey
Use the troubleshooters to help identify problems with clients. visit http://www.myitforum.com/cs2/blogs/gramsey for more information.
- SCCM 2007 GUID assistant by Greg Ramsey
Use this utility on a TEST SCCM 2007 site to help you identify the desired GUID required to extend the SCCM 2007 console.
- Restart Mul exe by sdesai
Restart all the systems in collection.
- SMS Site Status SideBar Gadget by fmerizalde130
This is the first of several Windows Vista SideBar Gadgets for providing SMS\SCCM information. This gadget, once configured will provide SMS Site Status.
- Program files application Blocker by rtruss
A small util to add blank files to the program files dir and remove permissions for local administrators, everyone and users groups and then add domain admins and whatever group you would like to add as well.
- ConfigMgr 2007 CCR creator tool by Chris Stauffer
- Dell Client Configuration Utility (DCCU)
Dell Client Configuration Utility (DCCU) is an application that you can use to obtain or configure BIOS settings. You can also restart or shut down the system or flash the BIOS with DCCU.
- SMSMap
Create Visio drawings of any combination of ConfigMgr 2007 and SMS 2003 Site Servers. Source: Tondware
- System Center Configuration Manager 2007 Toolkit
The ConfigMgr 2007 Toolkit contains 7 downloadable tools to help you manage and troubleshoot ConfigMgr 2007.
- System Center Updates Publisher (SCUP) 4.0
SCUP 4.0 allows customers to import software update catalogs, create, modify, and export software update definitions, and publish software updates.
- Enhanced System Discovery 2007 by System Center Tools
Provides a number of capabilities to improve your level of integration and synchronization with Active Directory.
- InventoryManager 2007 by Dudeworks
Inventory Manager (INVMAN) allows administrators to easily extend, customize and edit asset inventory for System Center Configuration Manager 2007 and SMS 2003.
- ConfigMgr Branch Distribution Point Bulk Add Tool CodePlex Project
BDPAdd is a tool that will bulk add protected branch distribution points to a ConfigMgr 2007 (SCCM) hierarchy. There is currently not a way, in the ConfigMgr console, to add multiple protected Branch distribution points at once. This tools attempts to address that problem.
- ConfigMgr Site Bound Tool CodePlex Project
This tool will bulk add boundaries to ConfigMgr sites.
- System Center Configuration Manager Driver Deleter CodePlex Project
The purpose of this application is to facilitate the deletion of multiple driver objects from a Microsoft System Center Configuration Manager 2007 (SCCM) database.
- SMS/SCCM Peer2Peer AddOn by Roger Zander
SMSTorrent is a Peer2Peer AddOn for SMS2003/SCCM2007 Clients. SMS/SCCM Clients are able to share the local Package cache with other Clients using the BitTorrent filesharing protocol.
- MIFCheck - MIFChecker allows you to verify a .MIF file (SMS 2.0 inventory file) for errors.
- Right-click Collection Listing by Matt Hudson
Right click on a computer or user and see what collection that resource is in as well as what maintanence window is associated with it.
- Mini Monster Mof Builder by Sherry Kissinger
- SCAP Conversion Tool for Desired Configuration Manager Microsoft
The SCAP Conversion Tool for DCM converts Security Content Automation Protocol (SCAP) files into DCM Configuration Packs and indicates gaps in a log file that can result from the conversion process. Use the Configuration Packs in combination with the desired configuration management (DCM) feature in Microsoft System Center Configuration Manager 2007 to monitor compliance with the SCAP baseline.
- WQL Analyzer - Browse classes, properties, qualifiers; run WQL queries (locally or remotely); save results as XML or HTML; connect to remote computer; export class description to XML or HTML; automatically generate the "SELECT" query (double click on class name).
Scripts¶
- VBScript Function for NOIDMIF Creation by rjones
VBScript Function for creating NOIDMIF files for SMS ad-hock inventory.
- Script to inventory certificates by Matthew Hudson & Sherry Kissinger
- Verify AMT certificates - Steve Rachui's Manageability blog. The CertValidator.vbs utility is designed to run on Windows 2003 and Windows 2008 servers.
Queries¶
Reports¶
Configuration Packs¶
- Microsoft Assessment Configuration Pack for ENERGY STAR Power Management for SC ConfigMgr 2007
ENERGY STAR is a joint program of the U.S. Environmental Protection Agency and the U.S. Department of Energy that helps save money and protect the environment through energy efficient products and practices. The ENERGY STAR guidelines for computers cover both the hardware devices and the power management features expected of the operating system and applications.
- IBM System Packs for Microsoft's System Center Configuration Manager (SCCM) - Catalog Readme User's Guide
Misc.¶
- ConfigMgr 2007 Visio Stencils
ConfigMgr (SCCM) 2007 Visio Stencils with example drawing.
- Microsoft Configuration Manager 2007 SP1 Asset Intelligence Catalog Update
This package will update the Asset Intelligence Configuration Manager SP1 catalog to fix the MPC issue, correcting the LU_MSProd table.
- SCCM 2007 Capacity Planner
Here is an updated Capacity Planner to work with SCCM 2007. This is not fully completed as it is a work in progress. But it has updated terminology and hardware recommendations which may be helpful to some people. The bandwidth used calculations are not updated although you can manipulate the data to give an estimation.
- TechNet Forums ConfigMgr Feeds OPML
Import this OPML into your favorite RSS reader to stream content posted to the ConfigMgr forums on TechNet.
Ron Crumbaker Web Remote Tools 3.21 Customizations or Additional buttons¶
- Filter Update Update the filter.
- Scroll Left Pane Make a change to allow for the left pane to be scroll-able.
- New Button: Alternate Lookup User for SLAT If you have SystemCenterTools.com's Security Login Audit Tool deployed, an alternate report to lookup a computer for a user.
- New Button: Roger Zander's SMS Client Center 1.1.3 Launch SMS Client Center v1.1.3 (Note, not designed for use with v2)
- New Button: SMS2003 Remote Tools Toggle It is assumed that the site setting is enabled; and this is to toggle disable on specific clients when needed.
- New Button: MSInfo32
--
----------------
Thanks
----------------
Tools and Utilities for ConfigMgr / SCCM 2007 Including beta's
- SCCM OU Collection Creator - Matthew Hudson
===Tools and Utilities===
- SccmAutoDoc Kim Oppalfens, who is a SCCM MVP, has released a neat utility called SccmAutoDoc. SccmAutoDoc is a command line utility that automatically documents an SCCM site into a human-readable form with minimal user input. Only the useful information is included, as opposed to items that are largely used internally.
- SMSNotify SMSNotify, by myITforum member Dan Thompson, presents the user with an informative screen that lets them know a package will install at a scheduled time and allows the user to postpone the installation for a future time. Many, many other features and options.
- ConfigMgr / SCCM / SMS Documentation Script v1.18 This vbs script will create detailed documentation for your ConfigMgr / SCCM / SMS server.
- ENGL Zwlancfg - ENGL. ENGL Zwlancfg is a tool that simplifies the unattended deployment of Microsoft wireless network settings to Windows XP and Vista machines. Profiles can be created, deleted, exported and imported. Zwlancfg can be run from the command line or from the Microsoft System Center Configuration Manager (SCCM) Task Sequence Plugin.
- ConfigMgr Branch DP Add - ddelgado1 on CodePlex. BDPAdd is a tool that will bulk add protected branch distribution points to a ConfigMgr 2007 (SCCM) hierarchy. There is currently not a way, in the ConfigMgr console, to add multiple protected Branch distribution points at once. This tools attempts to address that problem. (Note: The tool could be easily modified, if needed, to add unprotected branch DPs. I needed protected Branch DPs though, so that's what I wrote this for.
- ConfigMgr Site Bound Tool - ddelgado1 on CodePlex. SiteBound is a tool that allows bulk addition of boundaries to ConfigMgr (SCCM ) sites. Adding boundaries through the ConfigMgr console can be tedious if adding more than a handful. Previously for SMS 2003 there was the Siteboun.exe tool which solved this problem, however, to my knowledge there is not a version of this tool available for ConfigMgr 2007. If there is, then oh well I still learned something.
- Coretech SCCM Manager - Freeware- Coretech A/S
Formerly known as "Coretech Application Creator for SCCM" This utility is developed based on many years of experience with Microsoft System Management Server now System Center Configuration Manager. Our mission is to streamline every aspect of the package creation process thus making the daily administration of the system smarter. In the latest version you'll also find functionality to prestage computers and configure variables used in the image deployment process.
- ConfigMgr MP Policy Checker - Vincent Dipippo - I have written a tool that will allow you to select a policy and then check that policy via HTTP pulls to all of the MPs. The tool is multi-threaded for performance and works well in large environment.
- 1E Migration Tool - This tool is designed to allow an SMS Administrator to Migrate all or selected packages and programs from his SMS environment into a System Center Configuration Management (ConfigMgr) environment. The tool has the following features: The Migration of Package and Program details along with source files; Renaming of Package and Program names during migration; Direct transfer of packages from your SMS site to ConfigMgr; Export to flat file structure from SMS site and Import into ConfigMgr from flat file; Exporting of SMSNomad command line settings to new ConfigMgr Nomad tab settings.
- ConfigMgr Collection Query Rule Embedded Reference Checker - The tool enumerates all existing site codes, collections, and query rules on that server. It then uses regular expressions to detect probable collection references (i.e. any site code followed by 5 hex digits). There is also a special case for the built-in collections, which do not correspond to a site code (starting instead with SMS) and do not conform to the strict standard for user-created collections (e.g. SMSDM001, SMS000GS, etc.) Finally, it cross-references those collection IDs to the actual list of collections and includes them by ID and name for review. Any collection ID that is found in a rule but not in the collections enumerated from the server is reported as "**** Unknown ****". You can search the output for this to identify bad references.
- ConfigMgr Package Distribution Health Browser - While the console is quite functional in checking the distribution status of packages in general, I wrote a tool that helps administrators zero in on package replication issues much more quickly. First, it accesses the associated views in the database directly, which makes it much faster to get at this information than the console, which is a front-end to the ConfigMgr WMI provider. Second, it offers some sorting and filtering options that highlight the replication issues much more efficiently than reviewing the total status for every package individually.
- SCCM Client Center 2.0 or SCCM Client Center 2.0 by Roger Zander
- Wiki Documentation Documentation for SCCM Client Center 2.0
- Updates to MSI Updates when using MSI to install
- 1E's Service Window Provides a graphical interface that allows an administrative user to view, add, edit and delete maintenance windows (service windows) on a selected target computer. Maintenance windows define times during which Microsoft System Center Configuration Manager 2007(ConfigMgr) can apply advertisements and software update deployments to the specified computer. If no windows are specified then the computer can receive advertisements at any time. Administrators may assign advertisements outside any maintenance windows irrespective of what has been set.
- Collection Commander 1.3.1 by Roger Zander
Initiate SMS 2003 advanced client actions on a collection: Ping,WakeUp,HW/SW Inventory,ReRun Advertisements,Show logged on user,Download/Refresh Policy,Repair SMS Agents,Import Clients to the Collection.
- Web Remote Tools by Ron Crumbaker
-- Modifications and Additions to Web Remote Tools 3.21
- SCCM Right Click Tools by rhouchins
- SMS Server Tools 0 2 2 - By Bernard White
Suite of 7 tools including: 1. Management Point Ping (mpping.exe), 2. Site Information (siteinfo.exe), 3. Package Information (pkginfo.exe), 4. Distribution Point Mod (dpmod.exe), 5. Site Control File Check (scfcheck.exe), 6. Site Services (sitesvc.exe), 7. Collection Membership (cmember.exe). For more info see: http://netplantation.com
- SMS SCCMTroubleShooter by Greg Ramsey
Use the troubleshooters to help identify problems with clients. visit http://www.myitforum.com/cs2/blogs/gramsey for more information.
- SCCM 2007 GUID assistant by Greg Ramsey
Use this utility on a TEST SCCM 2007 site to help you identify the desired GUID required to extend the SCCM 2007 console.
- Restart Mul exe by sdesai
Restart all the systems in collection.
- SMS Site Status SideBar Gadget by fmerizalde130
This is the first of several Windows Vista SideBar Gadgets for providing SMS\SCCM information. This gadget, once configured will provide SMS Site Status.
- Program files application Blocker by rtruss
A small util to add blank files to the program files dir and remove permissions for local administrators, everyone and users groups and then add domain admins and whatever group you would like to add as well.
- ConfigMgr 2007 CCR creator tool by Chris Stauffer
- Dell Client Configuration Utility (DCCU)
Dell Client Configuration Utility (DCCU) is an application that you can use to obtain or configure BIOS settings. You can also restart or shut down the system or flash the BIOS with DCCU.
- SMSMap
Create Visio drawings of any combination of ConfigMgr 2007 and SMS 2003 Site Servers. Source: Tondware
- System Center Configuration Manager 2007 Toolkit
The ConfigMgr 2007 Toolkit contains 7 downloadable tools to help you manage and troubleshoot ConfigMgr 2007.
- System Center Updates Publisher (SCUP) 4.0
SCUP 4.0 allows customers to import software update catalogs, create, modify, and export software update definitions, and publish software updates.
- Enhanced System Discovery 2007 by System Center Tools
Provides a number of capabilities to improve your level of integration and synchronization with Active Directory.
- InventoryManager 2007 by Dudeworks
Inventory Manager (INVMAN) allows administrators to easily extend, customize and edit asset inventory for System Center Configuration Manager 2007 and SMS 2003.
- ConfigMgr Branch Distribution Point Bulk Add Tool CodePlex Project
BDPAdd is a tool that will bulk add protected branch distribution points to a ConfigMgr 2007 (SCCM) hierarchy. There is currently not a way, in the ConfigMgr console, to add multiple protected Branch distribution points at once. This tools attempts to address that problem.
- ConfigMgr Site Bound Tool CodePlex Project
This tool will bulk add boundaries to ConfigMgr sites.
- System Center Configuration Manager Driver Deleter CodePlex Project
The purpose of this application is to facilitate the deletion of multiple driver objects from a Microsoft System Center Configuration Manager 2007 (SCCM) database.
- SMS/SCCM Peer2Peer AddOn by Roger Zander
SMSTorrent is a Peer2Peer AddOn for SMS2003/SCCM2007 Clients. SMS/SCCM Clients are able to share the local Package cache with other Clients using the BitTorrent filesharing protocol.
- MIFCheck - MIFChecker allows you to verify a .MIF file (SMS 2.0 inventory file) for errors.
- Right-click Collection Listing by Matt Hudson
Right click on a computer or user and see what collection that resource is in as well as what maintanence window is associated with it.
- Mini Monster Mof Builder by Sherry Kissinger
- SCAP Conversion Tool for Desired Configuration Manager Microsoft
The SCAP Conversion Tool for DCM converts Security Content Automation Protocol (SCAP) files into DCM Configuration Packs and indicates gaps in a log file that can result from the conversion process. Use the Configuration Packs in combination with the desired configuration management (DCM) feature in Microsoft System Center Configuration Manager 2007 to monitor compliance with the SCAP baseline.
- WQL Analyzer - Browse classes, properties, qualifiers; run WQL queries (locally or remotely); save results as XML or HTML; connect to remote computer; export class description to XML or HTML; automatically generate the "SELECT" query (double click on class name).
Scripts¶
- VBScript Function for NOIDMIF Creation by rjones
VBScript Function for creating NOIDMIF files for SMS ad-hock inventory.
- Script to inventory certificates by Matthew Hudson & Sherry Kissinger
- Verify AMT certificates - Steve Rachui's Manageability blog. The CertValidator.vbs utility is designed to run on Windows 2003 and Windows 2008 servers.
Queries¶
Reports¶
Configuration Packs¶
- Microsoft Assessment Configuration Pack for ENERGY STAR Power Management for SC ConfigMgr 2007
ENERGY STAR is a joint program of the U.S. Environmental Protection Agency and the U.S. Department of Energy that helps save money and protect the environment through energy efficient products and practices. The ENERGY STAR guidelines for computers cover both the hardware devices and the power management features expected of the operating system and applications.
- IBM System Packs for Microsoft's System Center Configuration Manager (SCCM) - Catalog Readme User's Guide
Misc.¶
- ConfigMgr 2007 Visio Stencils
ConfigMgr (SCCM) 2007 Visio Stencils with example drawing.
- Microsoft Configuration Manager 2007 SP1 Asset Intelligence Catalog Update
This package will update the Asset Intelligence Configuration Manager SP1 catalog to fix the MPC issue, correcting the LU_MSProd table.
- SCCM 2007 Capacity Planner
Here is an updated Capacity Planner to work with SCCM 2007. This is not fully completed as it is a work in progress. But it has updated terminology and hardware recommendations which may be helpful to some people. The bandwidth used calculations are not updated although you can manipulate the data to give an estimation.
- TechNet Forums ConfigMgr Feeds OPML
Import this OPML into your favorite RSS reader to stream content posted to the ConfigMgr forums on TechNet.
Ron Crumbaker Web Remote Tools 3.21 Customizations or Additional buttons¶
- Filter Update Update the filter.
- Scroll Left Pane Make a change to allow for the left pane to be scroll-able.
- New Button: Alternate Lookup User for SLAT If you have SystemCenterTools.com's Security Login Audit Tool deployed, an alternate report to lookup a computer for a user.
- New Button: Roger Zander's SMS Client Center 1.1.3 Launch SMS Client Center v1.1.3 (Note, not designed for use with v2)
- New Button: SMS2003 Remote Tools Toggle It is assumed that the site setting is enabled; and this is to toggle disable on specific clients when needed.
- New Button: MSInfo32
--
----------------
Thanks
----------------