Contact us today|info@ctglobalservices.com
FacebookXLinkedIn

Om Kåre Rude Andersen

Microsoft Certified Trainer since 1996, MCSE, TS and ITP in Microsoft Windows, SQL (also Microsoft), Exchange (MS) and Microsoft Operations Manager. Senior Consultant and have recently worked as a consultant at CSC, SAS, ISS, Nokia and Scandlines.

Changing Alert Resolution State automatically

If you need to change the Resolution State when a new Alert appears, or change the status of an alert from a specific source or a given period of time, it could be done with a script. The script will be called by creating a Notification. Often you specify a SMTP, SMS or IM as a Channel but lets instead call a script – In this sample I will use a Powershell script to change new alerts Resolution state to the “Print Guys”. Lets start with creating a Command Notification Channel - Give it a name like this one: Start [...]

By |2011-03-21T18:30:42+01:00marts 21st, 2011|Operations Manager (SCOM)|6 Comments
Læs mere

Building a Discovery and a Group based on Computername Convention

To create a Group and a rollup for all your DNS servers like: DkCphDNS0xx you could create your own Management Pack like this walk through. The code used in the example is from Jonathan Almquist\s blogpost: http://blogs.technet.com/b/jonathanalmquist/archive/2010/04/28/how-to-create-a-computer-group-in-the-r2-authoring-console.aspx and in this example the code is like this: <RuleId>$MPElement$</RuleId> <GroupInstanceId>$MPElement[Name="MP_RWSiteServers.RWSiteServersGroup"]$</GroupInstanceId> <MembershipRules> <MembershipRule> <MonitoringClass>$MPElement[Name="Windows!Microsoft.Windows.Computer"]$</MonitoringClass> <RelationshipClass>$MPElement[Name="SC!Microsoft.SystemCenter.ComputerGroupContainsComputer"]$</RelationshipClass> <Expression> <Contains> <MonitoringClass>$MPElement[Name="MP_RWSiteServers.SiteServers"]$</MonitoringClass> </Contains> </Expression> </MembershipRule> </MembershipRules> </Configuration>

By |2017-08-22T13:09:03+01:00december 8th, 2010|Operations Manager (SCOM)|1 Kommentar
Læs mere

Timeout Expired on Report Server

One question I often get from System Center folks is about the SQL Reporting Services and report timeout. Unfortunately Microsoft have an default value on many report dataset which is to low for an production environment. The easy solution would be to edit the RSReportServer.Config XML file, I mean - in this file we have a Tag called SQLCommandTimeoutSeconds and would it be great if we could use this one. But in fact your Report server dosn't use the SQL timeout value specified in this file... Symptoms: If you see the error message: "An error occurred during client rendering" Like [...]

By |2010-09-03T19:53:46+01:00september 3rd, 2010|Configuration Manager (SCCM), SQL Server Reporting Services (SSRS)|2 Comments
Læs mere

WMI Inconsistent or Error 25205 Failed to Uninstall SDK MOF

In the past couple of years I have stumbled over this error when I install OpsMgr Clients - It seams like some products are doing naughty things with the WMI database, which then leaves the WMI repository in Inconsistent state. The way I correct this is by using the following recipe: Error when installing OpsMgr Agent: Symptoms: Check Properties on your computer, are there no information in Processor and Memory????? Resolution: 1)      Change to C:\windows\system32\wbem 2)      Run the command: winmgmt /verifyrepository 3)      Check the result: “WMI repository is INCONSISTENT” ? 4)      If so run the command: winmgmt /salvagerepository 5)      Check [...]

By |2010-04-29T11:24:50+01:00april 29th, 2010|Configuration Manager (SCCM), Operations Manager (SCOM)|4 Comments
Læs mere

Automate your group creation with Powershell

One of our very good customers are managing servers with an dedicated internal administrator as a primary contact for each server. They are managing this one to one relation with an Excel sheet. A while ago we talked about automating this group creation with powershell, so the last time Jacob and I was discussing Powershell in Operations Manager we found a solution - Jacob who is the best Danish Powershell Guru of cause did a superoptimization of my first script and now its up to you to test it on your own. Please change the first lines of the script to [...]

By |2010-03-17T14:03:06+01:00marts 17th, 2010|Operations Manager (SCOM), Powershell, Scripting & Development|9 Comments
Læs mere

Get 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 INNER JOIN Alert.vAlertResolutionState ON Alert.vAlert.AlertGuid = Alert.vAlertResolutionState.AlertGuid INNER JOIN Alert.vAlertDetail ON Alert.vAlertResolutionState.AlertGuid = Alert.vAlertDetail.AlertGuid INNER JOIN vManagedEntity ON Alert.vAlert.ManagedEntityRowId = vManagedEntity.ManagedEntityRowId Where (Alert.vAlertResolutionState = 255) Thanks to Michael Westergaard for his question about Resolved Alerts....

By |2009-12-18T10:57:54+01:00december 18th, 2009|Operations Manager (SCOM)|1 Kommentar
Læs mere

Great!! – 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 Operations Manager work and how to troubleshoot * Architecture * Operations Manager "Health Engine" * Troubleshooting * Troubleshooting discoveries and monitors * Troubleshooting health state changes * Troubleshooting the Operations Manager agent This module will explain management pack architecture and how to author a management pack * Architecture * OpsMgr Console vs Authoring console [...]

By |2009-06-21T22:58:16+01:00juni 21st, 2009|Operations Manager (SCOM)|40 Comments
Læs mere

Report 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 String strValues(0) = cItem.Name strValues(1) = cItem.Path strValues(2) = cItem.Type.ToString()strValues(3) = cItem.CreatedBy lstView.Items.Add(New ListViewItem(strValues))  Next End Sub Private Sub DisplayCurrentInfo()  Me.Cursor = Cursors.WaitCursor  'display item information in messagebox Dim item As ListViewItem = lstView.SelectedItems(0)  Dim strName As String = item.SubItems(0).Text  Dim strPath As String = [...]

By |2009-02-27T14:44:04+01:00februar 27th, 2009|SQL|Kommentarer lukket til Report Server Course
Læs mere

Powershell 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 Andersen ([email protected])          # # Bagground........: Utility to let helpdesk manage Activesync     # # .................: devices.                                      # #################################################################### #region Script Settings #<ScriptSettings xmlns="http://tempuri.org/ScriptSettings.xsd"> #  <ScriptPackager> #    <process>powershell.exe</process> #    <arguments /> #    <extractdir>c:\scripts</extractdir> #    <files /> #    <usedefaulticon>true</usedefaulticon> #    <showinsystray>false</showinsystray> #    <altcreds>true</altcreds> #    <efs>false</efs> #    <ntfs>false</ntfs> [...]

By |2009-02-11T17:05:46+01:00februar 11th, 2009|Powershell|1 Kommentar
Læs mere

Find 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 = _     "SELECT cn, objectClass FROM 'LDAP://dc=coretech,dc=intra' WHERE " _         & "objectClass ='msExchDynamicDistributionList'" Set objRecordSet = objCommand.Execute objRecordSet.MoveFirst Do Until objRecordSet.EOF    Wscript.Echo objRecordSet.Fields(1).Value    objRecordSet.MoveNext Loop

By |2009-02-10T17:17:15+01:00februar 10th, 2009|Scripting & Development|3 Comments
Læs mere

SQL 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 = null    Select @db = name    From sysdatabases    Where dbid = @dbid    if @db is not null       DBCC CheckDB( @db )    Set @dbid = @dbid + 1 End Reindex all tables in a database: EXEC sp_MSforeachtable @command1=“print ’?' DBCC DBREINDEX [...]

By |2009-02-10T10:01:21+01:00februar 10th, 2009|SQL|Kommentarer lukket til SQL 2005 Course
Læs mere