Finally there has been a free third party to copy and paste collection queries, advertisement, programs and packages in SCCM. This is long overdue and really should be basic functionality in any Microsoft Management Console snap-in. I’ve tested it out and it works well.
More details and download from http://blogs.microsoft.co.il/blogs/doli/archive/2011/04/27/sccm-copy-and-paste-context-menu-add-on.aspx.
I recently had a requirement to be able to email SCCM reports on a schedule in an environment without SQL reporting services. I achieved this by creating a VB script to create an email that has the report ASP page as the body of the email. The script I used and scheduled as a Windows scheduled task was:
Set objMessage = CreateObject("CDO.Message")
objMessage.Subject = "Computers that do NOT have ......"
objMessage.From = "firstname.lastname@example.org"
objMessage.To = "email@example.com"
'==This section provides the configuration information for the remote SMTP server.
'==Normally you will only change the server name or IP.
("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
'Name or IP of Remote SMTP Server
("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "smtp.server.address.here"
'Server port (typically 25)
("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
'==End remote SMTP server configuration section==
'The line below shows how to send a webpage from a remote site
Just change the variables for your environment.
In a recent case, I needed to run a report to work out which systems had a particular server (antivirus) installed but was in the STOPPED state. After modifying the sms_mof file:
[SMS_Report (TRUE) ]
and running a hardware inventory on all machines, I could then create a report with the following query:
v_R_System SYS Join
v_GS_SERVICE SERV On SYS.ResourceID = SERV.ResourceID
SERV.DisplayName0 = 'OfficeScanNT RealTime Scan' and SERV.State0 = 'Stopped'