22nd December 2009Monitoring Windows Service and Recovery Script
If you want to monitor a Service and run a predefinded recovery task follow this walkthrough:
Category: Operations Manager 2007 | Comment
18th December 2009Get information of Resolved Alerts in OpsMgr 2007
Resolved Alerts in Operations Manager is easy to extract from your DW and Operations Manager environment: In Powershell: Get-Alert | Where {$_.Resolutionstate -eq 255} | ft resolvedby Or if you need a query from OperationsManagerDW in SQL as a dataset in your report: SELECT Alert.vAlert.AlertName, Alert.vAlertResolutionState.ResolutionState, Alert.vAlertDetail.Owner, Alert.vAlertDetail.TicketId, Alert.vAlertResolutionState.StateSetByUserId, Alert.vAlert.RepeatCount, Alert.vAlert.RaisedDateTime, Alert.vAlert.AlertDescription, vManagedEntity.Path FROM Alert.vAlert [...]
Category: Operations Manager 2007 | Comment
21st June 2009Great!! – A new Operations Manager Course
A new 3 days Operations Manager (or Scom) course (# 50216) is showing up around August – I think the first course will be around the beginning october - Please email me kra[@]coretech.dk regarding participating on this Course. Kurset vil naturligvis blive tilbudt gennem vores samarbejdspartnere, Teknologisk, Global Knowledge og Microworld. God sommer – Kåre Course Outline How the ‘internals’ of [...]
Category: Operations Manager 2007 | Comment
14th April 2009Slides fra OpsMgr Seminar hos Global Knowledge
Hermed mine slides fra Global Seminaret den 14. april 2009. Mail endelig såfremt i ønsker flere oplysninger.
Category: Home | Comment
27th February 2009Report Server Course
Links: http://msdn.microsoft.com/en-us/library/ms153561.aspx http://msdn.microsoft.com/en-us/library/ms156500.aspx http://www.developer.com/db/article.php/10920_3727626_2 http://msdn.microsoft.com/en-us/library/ms157406(sql.90).aspx http://blogs.msdn.com/bwelcker/archive/tags/Reporting+Services/default.aspx http://www.sql-server-performance.com/articles/reporting/index.aspx http://lyon-smith.org/blogs/code-o-rama/archive/2007/03/22/visual-studio-column-guides-redux.aspx http://www.microsoft.com/downloads/details.aspx?familyid=9f783224-9871-4eea-b1d5-f3140a253db6&displaylang=en http://visualstudiomagazine.com/columns/article.aspx?editorialsid=1900 Husk Report Builder 2.0 Og her er koden i forbindelse med Report server kurset d 25. – 27 feb: Private Sub LoadInformation() ‘load information into list view lstView.Items.Clear() Dim myCatalogItems As CatalogItem()myCatalogItems = rs.ListChildren(“/”, True) For Each cItem As CatalogItem In myCatalogItems Dim strValues(3) As [...]
Category: SQL Scripts | Comments Off
11th February 2009Powershell Acticvesync wipe
In this Powershell sample (created with ASE) – its possible to create a simple form to let Helpdesk manage Activesync Devices, this is done by finding and wipe/unwipe the device. Feel free to change and clean-up – Try ASE – http://adminscripteditor.com/ – Its a great editor. #################################################################### # Program……….: ASExWipe.ps1 # # Author………..: Kåre Rude [...]
Category: Powershell | Comment
10th February 2009Find Query-based Distribution Groups in Domain
To find all QBD groups in your domain run the following. (Remember to change the LDAP string…) On Error Resume Next Const ADS_SCOPE_SUBTREE = 2 Set objConnection = CreateObject(“ADODB.Connection”) Set objCommand = CreateObject(“ADODB.Command”) objConnection.Provider = “ADsDSOObject” objConnection.Open “Active Directory Provider” Set objCommand.ActiveConnection = objConnection objCommand.Properties(“Page Size”) = 1000 objCommand.Properties(“Searchscope”) = ADS_SCOPE_SUBTREE objCommand.CommandText = _ [...]
Category: VBScript | 1 Comment
10th February 2009SQL 2005 Course
Samples, Utils and Links from MOC 2780 SQL 2005 Course. Check All Databases with undocumented stored procedure: EXEC SP_MSForEachDB @command1=”Print ‘?’ DBCC CHECKDB (‘?’)” Another track to the same station. Declare @db VarChar(100), @dbid int, @hidb int Select @hidb = Max(dbid ), @dbid = 0 from master..sysdatabases While @dbid < @hidb Begin Set @db = [...]
Category: SQL Scripts | Comment
Subscribe to Kåre's RSS Feed