Transaction SQL Date Calculations – First Day of Month and Last Day of Month

I find that I am consistently trying to determine the first and last day of the current month using Transact SQL. The following is a cheat sheet for calculating easily those dates: DECLARE @today DATETIME, @first_of_month DATETIME, @last_of_month DATETIME   SET @today = GETDATE() SET @first_of_month = DATEADD(dd,-(DATEPART(dd, @today)-1),@today) SET @last_of_month = DATEADD(dd, -1, DATEADD(mm,…

Intranet solution

How to add monitoring for a port or interface on a network device in Operations Manager 2012 (#SCOM, #SYSCTR)

  Operations Manager 2012 provides enhanced network monitoring capabilities which includes the ability to provide monitoring for various interfaces and ports on the network devices. While I have seen mentions about configuring monitoring for an additional network port or interface (such as http://technet.microsoft.com/en-us/library/hh212935.aspx which states that “Ports that are connected to a computer are not…

Config Mgr 2012 Mof modifications (SCCM 2012 MOF importing) (WORK IN PROGRESS)

It seems no matter how good SCCM becomes there will always be a need to modify the existing hardware inventory gathering.   I am not sure if I am NOT using the Reg2mof 2012 version correctly but so far my experience with the 2007 tool has been utter failure.   http://myitforum.com/cs2/blogs/skissinger/archive/2010/12/01/march-cochrane-s-regkeytomof-v2-5.aspx   I have used…