How to: Create custom SQL- based Reports in System Center 2012 R2: Configuration Manager

A customer asked me  for a “how-to” on how to Create reports in SCCM 2012, so why not share with everyone. This post is not intended to show how to write or design queries, but show you have to create  a report based on a SQL query you might already have. Even-though we are skipping […]

Category: Config Mgr. Inventory and Reporting, Configuration Manager 2012, Configuration Manager 2012 R2, Configuration Manager 2012 SP1, Home, Microsoft SQL, SQL Reporting services  |  1 Comment

Troubleshooter note: SQL Installation fails with exitcode 0x84BB0001 on a ReFS formatted partition.

So I tried to install SQL the other day for a new ConfigMgr environment, but I kept getting an error during the first seconds of the installation with 0x84BB0001 as the exit code. With some quick investigation into the log files I found this %Temp%\SqlSetup_Local.log: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\Summary.txt: Shows that the installation has […]

Category: Config Mgr, Configuration Manager, Configuration Manager 2012, Home, Microsoft SQL, Scripting, SQL and System Center, SQL Scripts  |  Comment

Metadata Only Updates in SCCM 2012 R2 Console

Been a while since i blogged – but this i felt needed to come up. If you work with Software Updates in SCCM then you are used to see Normal, Expired & Superseeded Updates from Microsoft… Not Metadata Only Updates! (Unless you work with SCUP or other 3rd party patching) – https://technet.microsoft.com/da-dk/library/hh848254.aspx But i just […]

Category: Configuration Manager 2012 R2, Software Updates, SQL Scripts, Troubleshooting  |  2 Comments

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 […]

Category: SQL Scripts  |  Comments Off on Report Server Course

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 = […]

Category: SQL Scripts  |  Comment