[mssms] Roles/permissions needed for image creation

[Heaton, Joseph@Wildlife]

I have assigned the Operating System Deployment Manager role to 2 people that 
are responsible for creating our Windows 10 gold image.  I assigned an empty 
collection to this as well.  What other rights, if any, would they need to be 
able to create/test the image?  I believe they'll use MDT in conjunction, as 
well.

Joe Heaton
Information Technology Operations Branch
Data and Technology Division
CA Department of Fish and Wildlife
1700 9th Street, 3rd Floor
Sacramento, CA  95811
Desk:  (916) 323-1284

Every Californian should conserve water.  Find out how at:
[SaveOurWater_Logo]
SaveOurWater.com * 
Drought.CA.gov

[mssms] RE: SCCM - Untrusted domain support

[Jason Sandys]

Well, the firewall has nothing to do with domains, forests or trusts so that's 
a completely separate issue. If you do have firewalls between the site server 
and system, then yes, you need to open the applicable ports in the firewall to 
allow communication.

J

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Brian McDonald
Sent: Wednesday, November 9, 2016 9:51 AM
To: mssms@lists.myitforum.com
Subject: [mssms] Re: SCCM - Untrusted domain support


What about firewall rules between the MP/DP/SUP in the remote domain and the 
Primary Site?


From: listsad...@lists.myitforum.com 
> on 
behalf of Jason Sandys >
Sent: Wednesday, November 9, 2016 11:04:52 AM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: SCCM - Untrusted domain support

There's really nothing very special about it. They need to be domain joined in 
that forest and you'll need a connection and installation account. That's truly 
it.

J

From: listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald
Sent: Wednesday, November 9, 2016 7:42 AM
To: mssms@lists.myitforum.com
Subject: [mssms] Re: SCCM - Untrusted domain support


Does anyone have any guidance/info/links on setting up DP/MP/SUP in untrusted 
domains? I think this is the direction I am leaning to go with supporting the 
requirements for my environment.



Thanks,

Brian


From: listsad...@lists.myitforum.com 
> on 
behalf of Jason Sandys >
Sent: Tuesday, November 8, 2016 11:29:27 AM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: SCCM - Untrusted domain support

Don't mix up AD domain trusts and certificate trust -- they are not the same 
thing. If you are using Microsoft enterprise CAs, they align, but that's only a 
convenience, not a hard-link or requirement.

J

-Original Message-
From: listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Mote, Todd
Sent: Tuesday, November 8, 2016 8:31 AM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: SCCM - Untrusted domain support

As far as my experience has shown me, I have three domains all untrusting of 
each other and the only way I can get all of those clients into the SCCM in our 
primary domain is by either each domain having its own CA, that you tell SCCM 
about, so it can verify the client cert chains, or issuing certificates from 
the primary domain's CA for all of the untrusted domain's clients.



-Original Message-
From: listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald
Sent: Monday, November 7, 2016 7:56 PM
To: mssms@lists.myitforum.com
Subject: [mssms] SCCM - Untrusted domain support

Hello,

We are in the process of severing domain trusts between our legacy domain(s) 
and new domain.

Domain A = New Domain (CM Current Branch)

Domain B = Old Legacy Domain #1 (CM 12R2 SP1)

Domain C = Old Legacy Domain # 2

Domain D = Old Legacy Domain # 3

In Domain B, I currently have SCCM 2012 R2 SP1 deployed. This environment 
supports clients in Domain A, B, C, D. As mentioned above, we will be Breaking 
domain trusts. The question I have is will I need to deploy Certs to support 
clients in these domains once the trust or broken? Are there any actions I need 
to take to support these clients once we break the trust between the domains?

Jason Sandy's responded to your previous email of mine, slightly different 
scenario that I was explaining. I'd like to know if the same rules apply here.

Eventually I will be migrating my SCCM infrastructure from Domain B to Domain 
A. Are there any other considerations I should be making as far as support with 
certificates?

Thanks,

Brian

Sent from my iPhone

[mssms] Re: November Security Only Update

[Brian McDonald]

This is likely the reason. I had to modify mine as well. You can see in 
wsyncmgr.log file it skips it b/c it's superseeded unless you make the SUP 
change.


So, now that the icon is in superseded status, will the update actually deploy 
from SCCM?


From: listsad...@lists.myitforum.com  on behalf 
of Enley, Carl 
Sent: Wednesday, November 9, 2016 12:58:13 PM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: November Security Only Update

Check to see if your SUP configuration is set to expire superseded updates 
immediately. I had to go in and set mine to expire them in 2 months and then 
re-sync my SUP to get the security only updates to show. I also had to go in to 
my ADR's and remove the filter on superseded=NO.

This seems like a big mess

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Heaton, Joseph@Wildlife
Sent: Wednesday, November 9, 2016 1:49 PM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: November Security Only Update

I'm not even seeing the Security Only updates, for any of the OSes.  Even with 
no filtering.  I am only seeing the Monthly rollup.  Even verified my 
categories and products.  No idea why it's not showing.

From: listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald
Sent: Wednesday, November 09, 2016 9:53 AM
To: mssms@lists.myitforum.com
Subject: [mssms] November Security Only Update


All,



Has anyone noticed the November, 2016 Security Only Update for Windows 7 
x64-based Systems (KB197867) is showing superseded already in SCCM? I believe 
this is because the Monthly Roll-up is also published, superseding the Security 
Only update. Real nice!



Can you deploy superseded updates from SCCM? Don't know that I've ever tried. I 
typically will remove superseded updates from SUGs on a regular basis.



Thank you,

Brian

[mssms] RE: OT: VMware CPUs for SQL

[Art Flores]

I agree, non-SSD disks are usually the bottleneck. If anyone wants to read up 
on maxdop, I did find a good pdf from the vmware website, just  copy/paste the 
document name into your favorite search engine.
sql-server-on-vmware-best-practices-guide.pdf

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Marcum, John
Sent: Wednesday, November 09, 2016 9:54 AM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: OT: VMware CPUs for SQL

I’ve found that CPU is rarely the bottleneck for virtual SQL servers. It’s 
almost always disk.

From: listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Art Flores
Sent: Monday, November 7, 2016 1:00 PM
To: mssms@lists.myitforum.com
Subject: [mssms] OT: VMware CPUs for SQL

[External Email]
Howdy Folks,
I finally got Ola Hallengren’s SQL server maintenance scripts installed and 
configured (And there was much rejoicing Yay!!).
In an effort to make sure SQL is running at top speed, I tried running the 
calculator linked at:
https://blogs.msdn.microsoft.com/sqlsakthi/p/maxdop-calculator-sqlserver/
referenced from:
http://www.systemcentercentral.com/tip-setting-sql-max-degree-of-parallelism-achieve-big-database-performance-gains/
After running the following powershell command for the calculator, the VM I 
created in my test lab shows these results:
Get-WmiObject -namespace "root\CIMV2" -class Win32_Processor -Property 
NumberOfCores | select NumberOfCores
[cid:image001.png@01D238F6.6E34CCB0]
Msinfo32 shows the following:
[cid:image002.jpg@01D23A88.7225D150]
***
The VM created by another team in production is showing the following results:
[cid:image004.png@01D238F6.6E34CCB0]
Msinfo32 shows the following:
[cid:image004.jpg@01D23A88.7225D150]
***
What is the best way to configure VMWare’s “number of virtual sockets” and 
“number of cores per socket” to give SQL the best performance?





Confidentiality Notice: This e-mail is from a law firm and may be protected by 
the attorney-client or work product privileges. If you have received this 
message in error, please notify the sender by replying to this e-mail and then 
delete it from your computer.

[mssms] RE: November Security Only Update

[Enley, Carl]

Check to see if your SUP configuration is set to expire superseded updates 
immediately. I had to go in and set mine to expire them in 2 months and then 
re-sync my SUP to get the security only updates to show. I also had to go in to 
my ADR's and remove the filter on superseded=NO.

This seems like a big mess

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Heaton, Joseph@Wildlife
Sent: Wednesday, November 9, 2016 1:49 PM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: November Security Only Update

I'm not even seeing the Security Only updates, for any of the OSes.  Even with 
no filtering.  I am only seeing the Monthly rollup.  Even verified my 
categories and products.  No idea why it's not showing.

From: listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald
Sent: Wednesday, November 09, 2016 9:53 AM
To: mssms@lists.myitforum.com
Subject: [mssms] November Security Only Update


All,



Has anyone noticed the November, 2016 Security Only Update for Windows 7 
x64-based Systems (KB197867) is showing superseded already in SCCM? I believe 
this is because the Monthly Roll-up is also published, superseding the Security 
Only update. Real nice!



Can you deploy superseded updates from SCCM? Don't know that I've ever tried. I 
typically will remove superseded updates from SUGs on a regular basis.



Thank you,

Brian

Re: [mssms] RE: Office 2013 to Office 2016 Upgrades

[Denzik, Josh]

Yes I've tried installing the kB2999226 which is what the vcred is trying to 
install. On some machines it has told me that the is not applicable to the 
workstation. Is there a prerequisite update that needs to be installed for 
KB2999226?

Sent from my iPhone

On Nov 9, 2016, at 12:52 PM, John Aubrey 
> wrote:



We ran into the Universal CRT issue when we upgraded a few weeks ago on a very 
small amount of machines. Have you tried to install the KB and see if it goes 
through then?

From: listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Denzik, Josh
Sent: Wednesday, November 9, 2016 11:18 AM
To: mssms@lists.myitforum.com
Subject: [mssms] Office 2013 to Office 2016 Upgrades

This message was sent securely by MUSC


All,

Just wondering if anyone has seen this issue below after an office 2016 upgrade:



Pretty much everyone says to install Visual C++ Redistributable for Visual 
Studio 2015 to fix the issue, but if fails on my machine and I never can get 
office to back on the machine properly. The problem is that the KB2999226 
(Universal CRT) which is part of the Visual C++ Redistributable for Visual 
Studio 2015 failed to install. The update is already present on the machine. 
This is only happening when I upgrade to office 2016 from 2013. Should this 
vcred be installed on the machines ahead of time?

-Josh





-
This message was secured via TLS by MUSC.





-
This message was secured via TLS by MUSC.

[mssms] RE: November Security Only Update

[Heaton, Joseph@Wildlife]

I'm not even seeing the Security Only updates, for any of the OSes.  Even with 
no filtering.  I am only seeing the Monthly rollup.  Even verified my 
categories and products.  No idea why it's not showing.

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Brian McDonald
Sent: Wednesday, November 09, 2016 9:53 AM
To: mssms@lists.myitforum.com
Subject: [mssms] November Security Only Update


All,



Has anyone noticed the November, 2016 Security Only Update for Windows 7 
x64-based Systems (KB197867) is showing superseded already in SCCM? I believe 
this is because the Monthly Roll-up is also published, superseding the Security 
Only update. Real nice!



Can you deploy superseded updates from SCCM? Don't know that I've ever tried. I 
typically will remove superseded updates from SUGs on a regular basis.



Thank you,

Brian

[mssms] Re: SCCM - Untrusted domain support

[Brian McDonald]

What about firewall rules between the MP/DP/SUP in the remote domain and the 
Primary Site?


From: listsad...@lists.myitforum.com  on behalf 
of Jason Sandys 
Sent: Wednesday, November 9, 2016 11:04:52 AM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: SCCM - Untrusted domain support

There's really nothing very special about it. They need to be domain joined in 
that forest and you'll need a connection and installation account. That's truly 
it.

J

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Brian McDonald
Sent: Wednesday, November 9, 2016 7:42 AM
To: mssms@lists.myitforum.com
Subject: [mssms] Re: SCCM - Untrusted domain support


Does anyone have any guidance/info/links on setting up DP/MP/SUP in untrusted 
domains? I think this is the direction I am leaning to go with supporting the 
requirements for my environment.



Thanks,

Brian


From: listsad...@lists.myitforum.com 
> on 
behalf of Jason Sandys >
Sent: Tuesday, November 8, 2016 11:29:27 AM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: SCCM - Untrusted domain support

Don't mix up AD domain trusts and certificate trust -- they are not the same 
thing. If you are using Microsoft enterprise CAs, they align, but that's only a 
convenience, not a hard-link or requirement.

J

-Original Message-
From: listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Mote, Todd
Sent: Tuesday, November 8, 2016 8:31 AM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: SCCM - Untrusted domain support

As far as my experience has shown me, I have three domains all untrusting of 
each other and the only way I can get all of those clients into the SCCM in our 
primary domain is by either each domain having its own CA, that you tell SCCM 
about, so it can verify the client cert chains, or issuing certificates from 
the primary domain's CA for all of the untrusted domain's clients.



-Original Message-
From: listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald
Sent: Monday, November 7, 2016 7:56 PM
To: mssms@lists.myitforum.com
Subject: [mssms] SCCM - Untrusted domain support

Hello,

We are in the process of severing domain trusts between our legacy domain(s) 
and new domain.

Domain A = New Domain (CM Current Branch)

Domain B = Old Legacy Domain #1 (CM 12R2 SP1)

Domain C = Old Legacy Domain # 2

Domain D = Old Legacy Domain # 3

In Domain B, I currently have SCCM 2012 R2 SP1 deployed. This environment 
supports clients in Domain A, B, C, D. As mentioned above, we will be Breaking 
domain trusts. The question I have is will I need to deploy Certs to support 
clients in these domains once the trust or broken? Are there any actions I need 
to take to support these clients once we break the trust between the domains?

Jason Sandy's responded to your previous email of mine, slightly different 
scenario that I was explaining. I'd like to know if the same rules apply here.

Eventually I will be migrating my SCCM infrastructure from Domain B to Domain 
A. Are there any other considerations I should be making as far as support with 
certificates?

Thanks,

Brian

Sent from my iPhone

[mssms] November Security Only Update

[Brian McDonald]

All,


Has anyone noticed the November, 2016 Security Only Update for Windows 7 
x64-based Systems (KB197867) is showing superseded already in SCCM? I believe 
this is because the Monthly Roll-up is also published, superseding the Security 
Only update. Real nice!


Can you deploy superseded updates from SCCM? Don't know that I've ever tried. I 
typically will remove superseded updates from SUGs on a regular basis.


Thank you,

Brian

[mssms] RE: Office 2013 to Office 2016 Upgrades

[John Aubrey]

We ran into the Universal CRT issue when we upgraded a few weeks ago on a very 
small amount of machines. Have you tried to install the KB and see if it goes 
through then?

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Denzik, Josh
Sent: Wednesday, November 9, 2016 11:18 AM
To: mssms@lists.myitforum.com
Subject: [mssms] Office 2013 to Office 2016 Upgrades

This message was sent securely by MUSC


All,

Just wondering if anyone has seen this issue below after an office 2016 upgrade:

[cid:image001.png@01D23A84.86A28E60]

Pretty much everyone says to install Visual C++ Redistributable for Visual 
Studio 2015 to fix the issue, but if fails on my machine and I never can get 
office to back on the machine properly. The problem is that the KB2999226 
(Universal CRT) which is part of the Visual C++ Redistributable for Visual 
Studio 2015 failed to install. The update is already present on the machine. 
This is only happening when I upgrade to office 2016 from 2013. Should this 
vcred be installed on the machines ahead of time?

-Josh





-
This message was secured via TLS by MUSC.

[mssms] RE: SCCM - Untrusted domain support

[Jason Sandys]

There's really nothing very special about it. They need to be domain joined in 
that forest and you'll need a connection and installation account. That's truly 
it.

J

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Brian McDonald
Sent: Wednesday, November 9, 2016 7:42 AM
To: mssms@lists.myitforum.com
Subject: [mssms] Re: SCCM - Untrusted domain support


Does anyone have any guidance/info/links on setting up DP/MP/SUP in untrusted 
domains? I think this is the direction I am leaning to go with supporting the 
requirements for my environment.



Thanks,

Brian


From: listsad...@lists.myitforum.com 
> on 
behalf of Jason Sandys >
Sent: Tuesday, November 8, 2016 11:29:27 AM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: SCCM - Untrusted domain support

Don't mix up AD domain trusts and certificate trust -- they are not the same 
thing. If you are using Microsoft enterprise CAs, they align, but that's only a 
convenience, not a hard-link or requirement.

J

-Original Message-
From: listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Mote, Todd
Sent: Tuesday, November 8, 2016 8:31 AM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: SCCM - Untrusted domain support

As far as my experience has shown me, I have three domains all untrusting of 
each other and the only way I can get all of those clients into the SCCM in our 
primary domain is by either each domain having its own CA, that you tell SCCM 
about, so it can verify the client cert chains, or issuing certificates from 
the primary domain's CA for all of the untrusted domain's clients.



-Original Message-
From: listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald
Sent: Monday, November 7, 2016 7:56 PM
To: mssms@lists.myitforum.com
Subject: [mssms] SCCM - Untrusted domain support

Hello,

We are in the process of severing domain trusts between our legacy domain(s) 
and new domain.

Domain A = New Domain (CM Current Branch)

Domain B = Old Legacy Domain #1 (CM 12R2 SP1)

Domain C = Old Legacy Domain # 2

Domain D = Old Legacy Domain # 3

In Domain B, I currently have SCCM 2012 R2 SP1 deployed. This environment 
supports clients in Domain A, B, C, D. As mentioned above, we will be Breaking 
domain trusts. The question I have is will I need to deploy Certs to support 
clients in these domains once the trust or broken? Are there any actions I need 
to take to support these clients once we break the trust between the domains?

Jason Sandy's responded to your previous email of mine, slightly different 
scenario that I was explaining. I'd like to know if the same rules apply here.

Eventually I will be migrating my SCCM infrastructure from Domain B to Domain 
A. Are there any other considerations I should be making as far as support with 
certificates?

Thanks,

Brian

Sent from my iPhone

[mssms] RE: I think i like the old web reporting more then Reporting Services.. seems simpler

[Garth Jones]

Hi John there are at least two books on how to write reports. Also watch my 
blog posts, as I regularly post tips on how to create nice reports. 

The reason why Ms got rid of the old ASP reports was because they would blowup 
at a drop of the hat. And they where ugly. The SSRS report are really really, 
really nice. :-)

-Original Message-
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Burke, John
Sent: November 9, 2016 6:16 AM
To: mssms@lists.myitforum.com
Subject: [mssms] I think i like the old web reporting more then Reporting 
Services.. seems simpler

Hi folks,

I'm having a horrid time trying to figure out how to really build custom 
reports in current branch vs 2007 web reports (didn't use the reporting 
services that much in 2007).  Anyone have a descent resource or article that 
would help me understand how to build custom reports without pulling my hair 
out?  I've looked about on the web and haven't really seen anything.  Web 
reports was so straight forward and simple, and it even let me browse the views 
and copy them into my sql statements. I'm still not sure why Microsoft got rid 
of it. 

[mssms] Office 2013 to Office 2016 Upgrades

[Denzik, Josh]

All,

Just wondering if anyone has seen this issue below after an office 2016 upgrade:

[cid:image001.png@01D23A7A.716D5F20]

Pretty much everyone says to install Visual C++ Redistributable for Visual 
Studio 2015 to fix the issue, but if fails on my machine and I never can get 
office to back on the machine properly. The problem is that the KB2999226 
(Universal CRT) which is part of the Visual C++ Redistributable for Visual 
Studio 2015 failed to install. The update is already present on the machine. 
This is only happening when I upgrade to office 2016 from 2013. Should this 
vcred be installed on the machines ahead of time?

-Josh






-
This message was secured via TLS by MUSC.

[mssms] RE: I think i like the old web reporting more then Reporting Services.. seems simpler

[Marcum, John]

You can still copy and paste in queries that you write in management studio

-Original Message-
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Burke, John
Sent: Wednesday, November 9, 2016 8:16 AM
To: mssms@lists.myitforum.com
Subject: [mssms] I think i like the old web reporting more then Reporting 
Services.. seems simpler

[External Email]

Hi folks,

I'm having a horrid time trying to figure out how to really build custom 
reports in current branch vs 2007 web reports (didn't use the reporting 
services that much in 2007).  Anyone have a descent resource or article that 
would help me understand how to build custom reports without pulling my hair 
out?  I've looked about on the web and haven't really seen anything.  Web 
reports was so straight forward and simple, and it even let me browse the views 
and copy them into my sql statements. I'm still not sure why Microsoft got rid 
of it.




Confidentiality Notice: This e-mail is from a law firm and may be protected by 
the attorney-client or work product privileges. If you have received this 
message in error, please notify the sender by replying to this e-mail and then 
delete it from your computer.

[mssms] RE: OT: VMware CPUs for SQL

[Marcum, John]

I’ve found that CPU is rarely the bottleneck for virtual SQL servers. It’s 
almost always disk.

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Art Flores
Sent: Monday, November 7, 2016 1:00 PM
To: mssms@lists.myitforum.com
Subject: [mssms] OT: VMware CPUs for SQL

[External Email]
Howdy Folks,
I finally got Ola Hallengren’s SQL server maintenance scripts installed and 
configured (And there was much rejoicing Yay!!).
In an effort to make sure SQL is running at top speed, I tried running the 
calculator linked at:
https://blogs.msdn.microsoft.com/sqlsakthi/p/maxdop-calculator-sqlserver/
referenced from:
http://www.systemcentercentral.com/tip-setting-sql-max-degree-of-parallelism-achieve-big-database-performance-gains/
After running the following powershell command for the calculator, the VM I 
created in my test lab shows these results:
Get-WmiObject -namespace "root\CIMV2" -class Win32_Processor -Property 
NumberOfCores | select NumberOfCores
[cid:image001.png@01D238F6.6E34CCB0]
Msinfo32 shows the following:
[cid:image002.jpg@01D23A6F.12B1AAA0]
***
The VM created by another team in production is showing the following results:
[cid:image004.png@01D238F6.6E34CCB0]
Msinfo32 shows the following:
[cid:image005.jpg@01D23A6F.12B1AAA0]
***
What is the best way to configure VMWare’s “number of virtual sockets” and 
“number of cores per socket” to give SQL the best performance?






Confidentiality Notice: This e-mail is from a law firm and may be protected by 
the attorney-client or work product privileges. If you have received this 
message in error, please notify the sender by replying to this e-mail and then 
delete it from your computer.

[mssms] Re: SCCM - Untrusted domain support

[Brian McDonald]

Does anyone have any guidance/info/links on setting up DP/MP/SUP in untrusted 
domains? I think this is the direction I am leaning to go with supporting the 
requirements for my environment.


Thanks,

Brian


From: listsad...@lists.myitforum.com  on behalf 
of Jason Sandys 
Sent: Tuesday, November 8, 2016 11:29:27 AM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: SCCM - Untrusted domain support

Don't mix up AD domain trusts and certificate trust -- they are not the same 
thing. If you are using Microsoft enterprise CAs, they align, but that's only a 
convenience, not a hard-link or requirement.

J

-Original Message-
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Mote, Todd
Sent: Tuesday, November 8, 2016 8:31 AM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: SCCM - Untrusted domain support

As far as my experience has shown me, I have three domains all untrusting of 
each other and the only way I can get all of those clients into the SCCM in our 
primary domain is by either each domain having its own CA, that you tell SCCM 
about, so it can verify the client cert chains, or issuing certificates from 
the primary domain's CA for all of the untrusted domain's clients.



-Original Message-
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Brian McDonald
Sent: Monday, November 7, 2016 7:56 PM
To: mssms@lists.myitforum.com
Subject: [mssms] SCCM - Untrusted domain support

Hello,

We are in the process of severing domain trusts between our legacy domain(s) 
and new domain.

Domain A = New Domain (CM Current Branch)

Domain B = Old Legacy Domain #1 (CM 12R2 SP1)

Domain C = Old Legacy Domain # 2

Domain D = Old Legacy Domain # 3

In Domain B, I currently have SCCM 2012 R2 SP1 deployed. This environment 
supports clients in Domain A, B, C, D. As mentioned above, we will be Breaking 
domain trusts. The question I have is will I need to deploy Certs to support 
clients in these domains once the trust or broken? Are there any actions I need 
to take to support these clients once we break the trust between the domains?

Jason Sandy's responded to your previous email of mine, slightly different 
scenario that I was explaining. I'd like to know if the same rules apply here.

Eventually I will be migrating my SCCM infrastructure from Domain B to Domain 
A. Are there any other considerations I should be making as far as support with 
certificates?

Thanks,

Brian

Sent from my iPhone

[mssms] RE: I think i like the old web reporting more then Reporting Services.. seems simpler

[Daniel Ratliff]

Reporting in 2012 and CB is just SSRS. Don't look for SCCM guides, look for 
SSRS guides on building reports with Report Builder or BIDS.

Daniel Ratliff

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Jimmy Martin
Sent: Wednesday, November 09, 2016 9:50 AM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: I think i like the old web reporting more then Reporting 
Services.. seems simpler


Do you have a sql resource?  I'm a visual person.  So the biggest head start I 
can give you is to use the Microsoft sql view creation gui in the sql console 
to create queries you can then drop into a sql report.  Since you have used 
sccm reports of past, you know the views you need to mess with.  Add all the 
views you want.  Join all the resourceid columns between the views, select the 
data you want in the report, create the where criteria...  then just cut the 
sql select statement into a report



[cid:image001.png@01D23A6F.AF942C30]



Jimmy Martin
(901) 227-8209

-Original Message-
From: listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Burke, John
Sent: Wednesday, November 9, 2016 8:16 AM
To: mssms@lists.myitforum.com
Subject: [mssms] I think i like the old web reporting more then Reporting 
Services.. seems simpler



Hi folks,



I'm having a horrid time trying to figure out how to really build custom 
reports in current branch vs 2007 web reports (didn't use the reporting 
services that much in 2007).  Anyone have a descent resource or article that 
would help me understand how to build custom reports without pulling my hair 
out?  I've looked about on the web and haven't really seen anything.  Web 
reports was so straight forward and simple, and it even let me browse the views 
and copy them into my sql statements. I'm still not sure why Microsoft got rid 
of it.









This message and any files transmitted with it may contain legally privileged, 
confidential, or proprietary information. If you are not the intended recipient 
of this message, you are not permitted to use, copy, or forward it, in whole or 
in part without the express consent of the sender. Please notify the sender of 
the error by reply email, disregard the foregoing messages, and delete it 
immediately.


P Please consider the environment before printing this email...



The information transmitted is intended only for the person or entity to which 
it is addressed
and may contain CONFIDENTIAL material.  If you receive this 
material/information in error,
please contact the sender and delete or destroy the material/information.

[mssms] RE: I think i like the old web reporting more then Reporting Services.. seems simpler

[Jimmy Martin]

Do you have a sql resource?  I'm a visual person.  So the biggest head start I 
can give you is to use the Microsoft sql view creation gui in the sql console 
to create queries you can then drop into a sql report.  Since you have used 
sccm reports of past, you know the views you need to mess with.  Add all the 
views you want.  Join all the resourceid columns between the views, select the 
data you want in the report, create the where criteria...  then just cut the 
sql select statement into a report



[cid:image001.png@01D23A66.329645F0]



Jimmy Martin
(901) 227-8209

-Original Message-
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Burke, John
Sent: Wednesday, November 9, 2016 8:16 AM
To: mssms@lists.myitforum.com
Subject: [mssms] I think i like the old web reporting more then Reporting 
Services.. seems simpler



Hi folks,



I'm having a horrid time trying to figure out how to really build custom 
reports in current branch vs 2007 web reports (didn't use the reporting 
services that much in 2007).  Anyone have a descent resource or article that 
would help me understand how to build custom reports without pulling my hair 
out?  I've looked about on the web and haven't really seen anything.  Web 
reports was so straight forward and simple, and it even let me browse the views 
and copy them into my sql statements. I'm still not sure why Microsoft got rid 
of it.










This message and any files transmitted with it may contain legally privileged, 
confidential, or proprietary information. If you are not the intended recipient 
of this message, you are not permitted to use, copy, or forward it, in whole or 
in part without the express consent of the sender. Please notify the sender of 
the error by reply email, disregard the foregoing messages, and delete it 
immediately.

P Please consider the environment before printing this email...

[mssms] I think i like the old web reporting more then Reporting Services.. seems simpler

[Burke, John]

Hi folks,

I'm having a horrid time trying to figure out how to really build custom 
reports in current branch vs 2007 web reports (didn't use the reporting 
services that much in 2007).  Anyone have a descent resource or article that 
would help me understand how to build custom reports without pulling my hair 
out?  I've looked about on the web and haven't really seen anything.  Web 
reports was so straight forward and simple, and it even let me browse the views 
and copy them into my sql statements. I'm still not sure why Microsoft got rid 
of it.