It's Christmas time again, and that means it's time for another SQL query for Service Manager reporting.
Do you use System Center Service Manager, and do you or your boss want to know how many Incident Requests the support team are resolving within the same day as it was created? If yes, then you are on the right blog post. Run the query below against the Data Warehouse database DWDataMart, and you will get a monthly trend report on resolved Incident Requests. Configure variables in the Query There are two variable in the Query you need to configure before you run it. SET @Year = 2014; define the year the request was resolved SET @Supportgroup = '1. [...]
In Service Manager we only have one view for User and Group configuration items, and many (including me) want to have views that separate users from groups, external users from Active Directory users and so on. This solution will add six additional views for user and group configuration items.
If you get the error "The data warehouse registration failed", when you try to register Service Manager with a Service Manager Data Warehouse server, it's maybe caused by the data and time formats settings for the service account on the Data Warehouse Management Server. Go to the Data Warehouse Management Server and log on with the service account, then set the data and time formats to English (United States) and log off. On the Service Manager Management Server, try to register with Service Manager Data Warehouse again. Hopefully this modification has solved the problem.
Do you have one or more mailboxes running in a wrong TimeZone on your Office 365 or Exchange environment? Don't worry it is easy to fix, and I will show you how do to it. Follow this blog post and you will learn how to see current TimeZone on a mailbox, how to change it, and how to changes TimeZone on all mailboxes.
There will be times where you want to give an administrator or another user access to another user's mailbox. This blog post will describe how to add and remove access permissions on one or more mailboxes with PowerShell.
The October 2011 release of Windows Intune is here, and that means new features and functionalities. I will with this blog post give you a short descriptions of the top features.
I just want to share the links I have being used and is using in my work with Office 365. The list will be updated regularly.
On Exchange Online Room mailboxes do not share calendar information by default. You will only be able to see if the Room is busy or not. This blog describe how you enable the Room's calendar to show more information to all users.
If you running Office 365 with Single Sign-on in a newly created Active Directory domain without an on-premise Exchange installation, you will missing the Exchange attributes. The Exchange attributes enable you to manage the exchange parameters on distribution list and mail enabled users through the Active Directory Users and Computers snap-in.
Using PowerShell is a great way to administering your Office 365 configuration. This blog will describe what you need to get started.
When you install Windows Intune Client Agent on your computers, you will see some new programs and services running on your client installations.
When you create AD user accounts through Active Directory Users and Computers, they don’t appear in the SBS Console. And therefore it is not possible to manage them from the Console. Run this VB script to add user accounts to the SBS console. Be sure to define the OU location for your users before running the script. The script don't add disabled accounts. [crayon-5ab197bd32307606577617/] Thanks to Jakob for providing me the code samples.