Creating Custom SCCM Reports using SQL Views

Bumped into this very interesting guide yesterday and I believe this would be an essential guide for those who are looking into creating custom reports for SCCM. The one I like the most is there documentation of the SCCM DB Schema altogether. Well not I can't see it from SQL Server, but now we have a documented description of the Database Schema altogether.

Interested? Get it from this link

http://www.microsoft.com/downloads/details.aspx?FamilyId=87BBE64E-5439-4FC8-BECC-DEB372A40F4A&displaylang=en

OR you can get it from my SkyDrive in case that link no longer valid.

http://cid-8b468d6e5c4e0782.skydrive.live.com/self.aspx/Public/CreatingCustomReportsByUsingSQLViews.msi

SNMP Simulator that you can use to Demo monitoring of network devices. using OpsMgr2007

One of the biggest challenge for us to demo performance monitoring of network devices to our clients would be the fact that we do not have a network device available during the demo session.

Jalasoft which offers the ability to extend OpsMgr capabilities in monitoring of network devices through it's Xian IO Network Manager has come out with a FREE SNMP simulation tool called Jalasoft SNMP Device Simulator v2.6. It has a user friendly user interface and allows you to simulate

• Cisco Switches
• Cisco Router
• Cisco Firewalls
• Cisco VPN Concentrators
• Cisco Wireless devices
• 3Com Switches
• HP Procurve Switches
• F5 BigIp
• Nortel
• APC UPS

For more information and where to download this free tool, go to this link:
http://www.jalasoft.com/Web/Product/Product.aspx?id=49