Troubleshooting MP on SCCM 2012 R2

Hi!

These days I’m going to upgrade a SCCM 2012 R2 to SCCM 1511 CB.

Checking the environment I see problems with the Management Point.

Verifying the mpcontrol.log I saw errors like these:

Call to HttpSendRequestSync failed for port 80 with status code 500, text: Internal Server Error SMS_MP_CONTROL_MANAGER

Http test request failed, status code is 500, ‘Internal Server Error’. SMS_MP_CONTROL_MANAGER  584 (0x0248) STATMSG: ID=5436 SEV=E LEV=M SOURCE=”SMS Server” COMP=”SMS_MP_CONTROL_MANAGER

To fix it I give user rights over C:\Program Files\SMS_CCM\SMS_MP folder and enabled directory browsing on SMS_MP web directory.

To verify I went to http://localhost/sms_mp/.sms_aut?mplist and http://localhost/sms_mp/.sms_aut?MPCert. It showed info correctly.

Regards!

Anuncios

SCCM query to populate Device collection

Hi!

In SCCM if you want to build a Device Query based on their OS version you can apply the following query:

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System   where    SMS_R_System.OperatingSystemNameandVersion like “%workstation%”   and SMS_R_System.OperatingSystemNameandVersion like “%6.2%” and SMS_G_System_COMPUTER_SYSTEM.SystemType = “x86-based PC”

Where %workstation% is to populate only workstations but if you prefeer servers change it for %server%

Where %6.2% is the OS version. In the below link you will find the OS version that you are loooking for, change it on the query 🙂

https://msdn.microsoft.com/en-us/library/windows/desktop/ms724832(v=vs.85).aspx

And also, if you need to know the architecture, you can indicate if 64 or 32 bits indicating “x86-based PC” or “x64-based PC” 

Regards!

 

Creating Device Query based on Language ID in SCCM

Hi!

To create a collection populated with computers based on their language ID use the following query:

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.OSLanguage = 3082

Where 3082 is the language ID that you are interested.

In the following link you can find all language IDs

https://msdn.microsoft.com/en-us/goglobal/bb964664.aspx

Regards!

Password for System Center 2012 R2 Preview Configuration Manager – Evaluation (VHD)

Hello!

Yesterday I have downloaded the System Center 2012 R2 Preview Configuration Manager – Evaluation (VHD)

https://www.microsoft.com/en-us/download/details.aspx?id=39368

Is funny that in any place you can see the password… then, seeking on internet I found it, it´s:

User: contoso\administrator

Password: R2Preview!

Regards!

SCCM Colections based on computer arquitecture

Hello,

In SCCM we can do querys based on computer arquitecture. If we need to make a colection that shows all x86 OS versions or x64 we can do the following query:

x86:

select distinct SMS_R_System.ResourceId,
SMS_R_System.ResourceType,
SMS_R_System.Name,
SMS_R_System.SMSUniqueIdentifier,
SMS_R_System.ResourceDomainORWorkgroup,
SMS_R_System.Client from SMS_R_System
inner join
SMS_G_System_COMPUTER_SYSTEM
on
SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId
where
SMS_G_System_COMPUTER_SYSTEM.SystemType = “x86-based PC”

x64:

select distinct SMS_R_System.ResourceId,
SMS_R_System.ResourceType,
SMS_R_System.Name,
SMS_R_System.SMSUniqueIdentifier,
SMS_R_System.ResourceDomainORWorkgroup,
SMS_R_System.Client from SMS_R_System
inner join
SMS_G_System_COMPUTER_SYSTEM
on
SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId
where
SMS_G_System_COMPUTER_SYSTEM.SystemType = “x64-based PC”

Regards!

Query to discover objects in AD from a SCCM Collection

Hi,

When you generate a collection in SCCM and want that appear all objects that are in a AD Sub OU you can use the following query:

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.SystemOUName = “DOMAIN/SERVERS_OU/SUB_OU”

Regards!

SCCM – How to create collections of machines based on subnet queries

Hi,

IN SCCM we can do a collection of machines based on subnet query with the following:.

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.IPSubnets = “X.X.X.X”

If you want to do queries with various subnets you can use this:

select *  from  SMS_R_System where SMS_R_System.IPSubnets in (“X.X.X.X”,”X.X.X.X”)

Regards