List of PC by Excel versions

I don’t remember where I got this. Here’s a simple report template to show List of PC by Excel Versions

SELECT DISTINCT
R.Name0 AS ‘Machine Name’,
left(SF.FileVersion,2)
FROM
dbo.v_R_System R
INNER JOIN dbo.v_GS_SoftwareFile SF ON R.ResourceID = SF.ResourceID
Join dbo.v_GS_SYSTEM S ON R.ResourceID = S.ResourceID
WHERE
S.SystemRole0 = ‘Workstation’
AND SF.FileName = ‘excel.exe’
AND SF.FilePath LIKE ‘C:\Program Files%’
ORDER BY
R.Name0

Advertisements

Extracting prestage files

Edmund’s Blog | My Client Management experience

1. Locate ExtractContent.exe from SCCM DP install directory.
Eg, E:\SMS_DP$\sms\Tools\ExtractContent.exe

2. Run this command to extract the content
ExtractContent.exe /P:c:\FolderName\PackageName.Pkgx /f

Enjoy!

iOS App Catalog for Microsoft Intune just got better!

It just getting better and better that makes the subscription worth the price. Company portal app has been updated with some nice change.

Read the post here

ConfigMgr 2012 R2 SP1 & ConfigMgr 2012 SP2 have been Released!

These releases have been announced at Microsoft Ignite and are now generally available & can be downloaded from Microsoft evaluation center.

Also included in these service packs are new hybrid features for customers using System Center Configuration Manager integrated with Microsoft Intune to manage devices. Some of the hybrid features that you can expect to see are conditional access policy, mobile application management, and support for Apple Device Enrollment Program (DEP). You can view the full list of hybrid features included in these service packs here.

ConfigMgr 2012 R2 Site Component Manager failed to install component SMS_PORTALWEB_CONTROL_MANAGER on server

Found an error from Component Status that SMS_PORTALWEB_CONTROL_MANAGER has failed.

image

Solution: This has always been the issue with IIS ASP.NET. Ensure the latest ASP.NET version is successfully registered.

Launch Command Prompt

Go to %Windir%\Microsoft.NET\Framework\<latest_version>

Run this command –> aspnet_regiis.exe –i

Change User Profile Default Location in Windows 7

Found a nice site to guide us on how to change the default user profile location.

Please refer to the full guide here

SCCM 2012 Console not connecting to Database

Encountered some operator machines that they are not able to connect to their SCCM Console. Below is the error screenshot.

image

Checked DCOM & even repaired WMI doesn’t help to resolve it. Found something interesting from SMSAdminUI.log (from %ProgramFiles%\Configuration Manager\Console\AdminUILog) and found errors contains The performance counter ‘# result objects in memory’ was not found.

Fix this by running a command, LODCTR /R

Once complete, you should get a message as below:
image

Reinstall SCCM Console and your console should be able to launch and connect to SCCM now.