[mssms] RE: understanding Software Metering Data

[Garth Jones]

Hi Stuart, It would be a whole hour of usage. 


Garth Jones
Chief Architect
Configuration Manager/SCCM Reporting

-Original Message-
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Stuart Watret
Sent: Monday, January 8, 2018 9:28 AM
To: mssms@lists.myitforum.com
Subject: [mssms] understanding Software Metering Data

Google skills have let me down.

Anyone have a good link or explanation of the data in a software metering 
report?

total usages = how many times it was opened and closed?

specifically, if someone opens something, leaves it minimised and closes it 
after an hour is that whole hour classed as usage? (even though they 
technically were not using it)

Ta

S.

RE: [mssms] Identify who ran an update on a top-level limiting collection

[Garth Jones]

Just remember that is you look at the properties make no change and click OK. 
That would generate a Status message saying that the collection has changed.




Garth Jones
Chief Architect
See us at Microsoft Ignite in booth 
#1246!<https://www.enhansoft.com/conferences/microsoft-ignite-2017>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Daniel Ratliff
Sent: Friday, November 10, 2017 4:28 PM
To: mssms@lists.myitforum.com
Subject: RE: [mssms] Identify who ran an update on a top-level limiting 
collection

Awesome, thanks Mike. Trying it now…

Daniel Ratliff

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Mike Dougherty
Sent: Friday, November 10, 2017 4:17 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: Re: [mssms] Identify who ran an update on a top-level limiting 
collection

You could run a status message query for

"All Status Messages from a specific component at a specific site".

Component is: "Microsoft.ConfigurationManagement.exe"
Provide the Site Code and time when prompted.

The status message in question will have a description along the lines of:

User "DOMAIN\User" requested that the membership be refreshed for collection 
"CollectionName" (CollectionID)

Of course, this only works if they updated the membership via the console.

If they used a script or something else other than the console, you could try 
the query against the component "Unknown Application".






On Fri, Nov 10, 2017 at 2:00 PM, Daniel Ratliff 
<dratl...@humana.com<mailto:dratl...@humana.com>> wrote:
Short of scouring colleval.log, does anyone have a way to identify who could 
have updated membership on a limiting collection causing the below picture?

It is from CEviewer and yes, its nearly 6000 collections. Now I am waiting 2-3 
hours before the collection I need will update. This is the 2nd time this week, 
so just trying to find the culprit to slap their hand and force them to re-read 
our best practices doc.

[cid:image001.png@01D35BB8.090AD010]

I was thinking setup a status filter rule when any of our limiting collections 
are updated manually. Have not researched that just yet.

Any other ideas?

Daniel Ratliff


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.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights 
laws and
do not discriminate on the basis of race, color, national origin, age, 
disability or
sex. Humana Inc. and its subsidiaries do not exclude people or treat them 
differently
because of race, color, national origin, age, disability or sex.

English: ATTENTION: If you do not speak English, language assistance services, 
free
of charge, are available to you. Call 1‐877‐320‐1235<tel:(877)%20320-1235> 
(TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 
1‐877‐320‐1235<tel:(877)%20320-1235> (TTY: 711).

繁體中文(Chinese)：注意：如果您使用繁體中文，您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235<tel:(877)%20320-1235> (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis 
èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235<tel:(877)%20320-1235> 
(TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235<tel:(877)%20320-1235> (TTY: 
711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235<tel:(877)%20320-1235> (TTY: 711)번으로 전화해 주십시오.




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.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights 
laws and
do not discriminate on the basis of race, color, national origin, age, 
disability or
sex. Humana Inc. and its subsidiaries do not exclude people or treat them 
differently
because of race, color, national origin, age, disability or sex.

English: ATTENTION: If you do not speak English, language assistance services, 
free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese)：注意：如果您使用繁體中文，您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis 
èd
pou lang ki disponib gratis pou 

[mssms] RE: Prevent custom hardware inventory class from keeping history?

[Garth Jones]

Hi Daniel, I know of no way to do this, short of setting the age inventory 
setting for all inventory.




Garth Jones
Chief Architect
See us at Microsoft Ignite in booth 
#1246!<https://www.enhansoft.com/conferences/microsoft-ignite-2017>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Daniel Ratliff
Sent: Wednesday, November 1, 2017 7:35 AM
To: mssms@lists.myitforum.com
Subject: [mssms] Prevent custom hardware inventory class from keeping history?

I am having no luck finding a way to do this. Does anyone know how to prevent 
custom hardware inventory classes from keeping history?

Thanks!

Daniel Ratliff


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.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights 
laws and
do not discriminate on the basis of race, color, national origin, age, 
disability or
sex. Humana Inc. and its subsidiaries do not exclude people or treat them 
differently
because of race, color, national origin, age, disability or sex.

English: ATTENTION: If you do not speak English, language assistance services, 
free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese)：注意：如果您使用繁體中文，您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis 
èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.

[mssms] RE: Inventory question

[Garth Jones]

Technically, it is not supported to truncate the tables. Yes, sherry has a blog 
post on this.

If you remove the services from being inventoried, it should also remove the 
data too.




Garth Jones
Chief Architect
See us at Microsoft Ignite in booth 
#1246!<https://www.enhansoft.com/conferences/microsoft-ignite-2017>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of henry.wil...@sanofi.com
Sent: Monday, September 18, 2017 9:02 AM
To: mssms@lists.myitforum.com
Subject: [mssms] Inventory question

Hello
We finally received approval to stop inventorying the "Services" information 
from the clients!  As it's our 10th largest table my question is when we 
disable this client setting - is it OK to truncate the tables - Services_DATA 
and Services_HIST tables or am I playing with fire on that one?

Also, I remember Sherry describing how to inventory a specific service - Does 
anyone have a link to that?  I was just on her blog and didn't see it
Thanks

Best regards / Cordialement

Henry E. WILSON
Technical Expert Engineer
Information Technology & Solutions
Infrastructure Management
Automation Services
55 Corporate Drive
Bridgewater, NJ 08807
TEL.: +1 908 981 3288
CELL.: +1 610 724 1169
FAX: +1 908 635 5858
[cid:image001.jpg@01D3305F.53412140]

[mssms] RE: Report clocking. Used to work in 2007 but not in CB

[Garth Jones]

Hi John, I commented out those columns because I don't have them added to my 
test lab.

You can use left outer join too, but you don't ever want full outer joins. That 
is begging for trouble.

A quick look at the query suggests that the only view you want an out join on 
is the v_r_user one.






Garth Jones
Chief Architect
See us at Microsoft Ignite in booth 
#1246!<https://www.enhansoft.com/conferences/microsoft-ignite-2017>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Burke, John
Sent: Friday, September 1, 2017 10:34 AM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: Report clocking. Used to work in 2007 but not in CB

I did add the User attributes to discovery for "manager, employeeID, department 
and title".   I noticed you commented them out. Safe to enable them again?  
Getting employee info is super important.

When using Inner Joins - I don't always get a ROW entry for every pc.  I need 
to make sure I always get a row entry, even if that "extra" info is empty.

If I change it to inner joins will it still give me a row entry for every item 
in the collection?

Thoughts on why it works for smaller number collections?

Didn't upgrade SQL recently.

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones
Sent: Thursday, August 31, 2017 7:17 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] RE: Report clocking. Used to work in 2007 but not in CB

This query will work in CMCB but only if you added the user discovery items to 
it, PLUS you really need to change the Full outer joins to inner joins.

Did you upgrade SQL Server version recently?

I used one of the Query formatter  
https://www.enhansoft.com/blog/query-formatting-tools to make it more readable.

I quickly fixed up a number of things.

On my slow VM with 20,000 computers, this took just over 4 minutes to run.


SELECT DISTINCT
   R.Name0 ,
   R.Client_Version0 ,
   R.Operating_System_Name_and0 ,
   R.Creation_Date0 ,
   CS.Model0 ,
   R.AD_Site_Name0 ,
   R.Distinguished_Name0 AS Expr1 ,
   MAX(OU.System_OU_Name0) AS SystemOUName ,
   R.User_Name0 ,
   U.Full_User_Name0 ,
   U.Mail0 ,
--U.employeeID0 ,
--U.department0 ,
--U.title0 ,
   @CollID AS CollectionID ,
   R.Resource_Domain_OR_Workgr0 ,
   R.Active0,
   R.Client0
FROM
   dbo.v_R_System AS R
   INNER JOIN dbo.v_R_User as U ON U.User_Name0 = R.User_Name0
   INNER JOIN dbo.v_GS_COMPUTER_SYSTEM as CS ON R.ResourceID = CS.ResourceID
   INNER JOIN dbo.v_FullCollectionMembership AS fcm ON R.ResourceID = 
fcm.ResourceID  and fcm.CollectionID = @CollID
   INNER JOIN dbo.v_RA_System_SystemOUName as OU ON R.ResourceID = 
OU.ResourceID
GROUP BY
   R.Name0 ,
   R.Client_Version0 ,
   R.Operating_System_Name_and0 ,
   R.Creation_Date0 ,
   CS.Model0 ,
   R.User_Name0 ,
   U.Full_User_Name0 ,
   U.Mail0 ,
--U.employeeID0 ,
--U.department0 ,
--U.title0 ,
   U.Distinguished_Name0 ,
   R.AD_Site_Name0 ,
   R.Distinguished_Name0 ,
   R.Resource_Domain_OR_Workgr0 ,
   R.Active0 ,
   R.Client0
ORDER BY
   R.Name0




Garth Jones
Chief Architect
See us at Microsoft Ignite in booth 
#1246!<https://www.enhansoft.com/conferences/microsoft-ignite-2017>

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Burke, John
Sent: Thursday, August 31, 2017 11:11 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] Report clocking. Used to work in 2007 but not in CB

HI,

This report works on smaller collections, but when I bump it up to all systems 
(with 5) systems it just runs for hours and hours and never ends.  It runs 
on collections with 7000 or so in them.

Is there something busted in it?  I basically want a row for every pc in the 
collection no matter what.

SELECT DISTINCT
 SYS.Name0, SYS.Client_Version0, 
SYS.Operating_System_Name_and0, SYS.Creation_Date0, 
v_GS_COMPUTER_SYSTEM.Model0, SYS.AD_Site_Name0,
 SYS.Distinguished_Name0 AS Expr1, 
MAX(v_RA_System_SystemOUName.System_OU_Name0) AS SystemOUName, SYS.User_Name0,
 v_R_User.Full_User_Name0, v_R_User.Mail0, 
v_R_User.employeeID0, v_R_User.department0, v_R_User.title0, @CollID AS 
CollectionID,
 SYS.Resource_Domain_OR_Workgr0, SYS.Active0, 
SYS.Client0
FROMv_R_System AS SYS FULL OUTER JOIN
 v_R_User ON v_R_User.User_Name0 = SYS.User_Name0 FULL 
OUTER JOIN
 v_GS_COMPUTER_SYSTEM ON 
v_GS_COMPUTER_SYSTEM.ResourceID = SYS.ResourceID INNER JOIN
 v_FullCollect

[mssms] RE: Report clocking. Used to work in 2007 but not in CB

[Garth Jones]

As Jason stated this will do nothing for you.




Garth Jones
Chief Architect
See us at Microsoft Ignite in booth 
#1246!<https://www.enhansoft.com/conferences/microsoft-ignite-2017>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Burke, John
Sent: Friday, September 1, 2017 11:07 AM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: Report clocking. Used to work in 2007 but not in CB

Besides the joins possibly - could this sort of thing apply to CB sQL reporting 
?

https://nikifoster.wordpress.com/2011/01/31/sccm-reporting-the-1-limit-and-report-timeouts/#comment-1045

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Burke, John
Sent: Friday, September 01, 2017 11:34 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] RE: Report clocking. Used to work in 2007 but not in CB

I did add the User attributes to discovery for "manager, employeeID, department 
and title".   I noticed you commented them out. Safe to enable them again?  
Getting employee info is super important.

When using Inner Joins - I don't always get a ROW entry for every pc.  I need 
to make sure I always get a row entry, even if that "extra" info is empty.

If I change it to inner joins will it still give me a row entry for every item 
in the collection?

Thoughts on why it works for smaller number collections?

Didn't upgrade SQL recently.

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones
Sent: Thursday, August 31, 2017 7:17 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] RE: Report clocking. Used to work in 2007 but not in CB

This query will work in CMCB but only if you added the user discovery items to 
it, PLUS you really need to change the Full outer joins to inner joins.

Did you upgrade SQL Server version recently?

I used one of the Query formatter  
https://www.enhansoft.com/blog/query-formatting-tools to make it more readable.

I quickly fixed up a number of things.

On my slow VM with 20,000 computers, this took just over 4 minutes to run.


SELECT DISTINCT
   R.Name0 ,
   R.Client_Version0 ,
   R.Operating_System_Name_and0 ,
   R.Creation_Date0 ,
   CS.Model0 ,
   R.AD_Site_Name0 ,
   R.Distinguished_Name0 AS Expr1 ,
   MAX(OU.System_OU_Name0) AS SystemOUName ,
   R.User_Name0 ,
   U.Full_User_Name0 ,
   U.Mail0 ,
--U.employeeID0 ,
--U.department0 ,
--U.title0 ,
   @CollID AS CollectionID ,
   R.Resource_Domain_OR_Workgr0 ,
   R.Active0,
   R.Client0
FROM
   dbo.v_R_System AS R
   INNER JOIN dbo.v_R_User as U ON U.User_Name0 = R.User_Name0
   INNER JOIN dbo.v_GS_COMPUTER_SYSTEM as CS ON R.ResourceID = CS.ResourceID
   INNER JOIN dbo.v_FullCollectionMembership AS fcm ON R.ResourceID = 
fcm.ResourceID  and fcm.CollectionID = @CollID
   INNER JOIN dbo.v_RA_System_SystemOUName as OU ON R.ResourceID = 
OU.ResourceID
GROUP BY
   R.Name0 ,
   R.Client_Version0 ,
   R.Operating_System_Name_and0 ,
   R.Creation_Date0 ,
   CS.Model0 ,
   R.User_Name0 ,
   U.Full_User_Name0 ,
   U.Mail0 ,
--U.employeeID0 ,
--U.department0 ,
--U.title0 ,
   U.Distinguished_Name0 ,
   R.AD_Site_Name0 ,
   R.Distinguished_Name0 ,
   R.Resource_Domain_OR_Workgr0 ,
   R.Active0 ,
   R.Client0
ORDER BY
   R.Name0




Garth Jones
Chief Architect
See us at Microsoft Ignite in booth 
#1246!<https://www.enhansoft.com/conferences/microsoft-ignite-2017>

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Burke, John
Sent: Thursday, August 31, 2017 11:11 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] Report clocking. Used to work in 2007 but not in CB

HI,

This report works on smaller collections, but when I bump it up to all systems 
(with 5) systems it just runs for hours and hours and never ends.  It runs 
on collections with 7000 or so in them.

Is there something busted in it?  I basically want a row for every pc in the 
collection no matter what.

SELECT DISTINCT
 SYS.Name0, SYS.Client_Version0, 
SYS.Operating_System_Name_and0, SYS.Creation_Date0, 
v_GS_COMPUTER_SYSTEM.Model0, SYS.AD_Site_Name0,
 SYS.Distinguished_Name0 AS Expr1, 
MAX(v_RA_System_SystemOUName.System_OU_Name0) AS SystemOUName, SYS.User_Name0,
 v_R_User.Full_User_Name0, v_R_User.Mail0, 
v_R_User.employeeID0, v_R_User.department0, v_R_User.title0, @CollID AS 
CollectionID,
 SYS.Resource_Domain_OR_Workgr0, SYS.Active0, 
SYS.Client0
FROM   

[mssms] RE: Report clocking. Used to work in 2007 but not in CB

[Garth Jones]

This query will work in CMCB but only if you added the user discovery items to 
it, PLUS you really need to change the Full outer joins to inner joins.

Did you upgrade SQL Server version recently?

I used one of the Query formatter  
https://www.enhansoft.com/blog/query-formatting-tools to make it more readable.

I quickly fixed up a number of things.

On my slow VM with 20,000 computers, this took just over 4 minutes to run.


SELECT DISTINCT
   R.Name0 ,
   R.Client_Version0 ,
   R.Operating_System_Name_and0 ,
   R.Creation_Date0 ,
   CS.Model0 ,
   R.AD_Site_Name0 ,
   R.Distinguished_Name0 AS Expr1 ,
   MAX(OU.System_OU_Name0) AS SystemOUName ,
   R.User_Name0 ,
   U.Full_User_Name0 ,
   U.Mail0 ,
--U.employeeID0 ,
--U.department0 ,
--U.title0 ,
   @CollID AS CollectionID ,
   R.Resource_Domain_OR_Workgr0 ,
   R.Active0,
   R.Client0
FROM
   dbo.v_R_System AS R
   INNER JOIN dbo.v_R_User as U ON U.User_Name0 = R.User_Name0
   INNER JOIN dbo.v_GS_COMPUTER_SYSTEM as CS ON R.ResourceID = CS.ResourceID
   INNER JOIN dbo.v_FullCollectionMembership AS fcm ON R.ResourceID = 
fcm.ResourceID  and fcm.CollectionID = @CollID
   INNER JOIN dbo.v_RA_System_SystemOUName as OU ON R.ResourceID = 
OU.ResourceID
GROUP BY
   R.Name0 ,
   R.Client_Version0 ,
   R.Operating_System_Name_and0 ,
   R.Creation_Date0 ,
   CS.Model0 ,
   R.User_Name0 ,
   U.Full_User_Name0 ,
   U.Mail0 ,
--U.employeeID0 ,
--U.department0 ,
--U.title0 ,
   U.Distinguished_Name0 ,
   R.AD_Site_Name0 ,
   R.Distinguished_Name0 ,
   R.Resource_Domain_OR_Workgr0 ,
   R.Active0 ,
   R.Client0
ORDER BY
   R.Name0




Garth Jones
Chief Architect
See us at Microsoft Ignite in booth 
#1246!<https://www.enhansoft.com/conferences/microsoft-ignite-2017>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Burke, John
Sent: Thursday, August 31, 2017 11:11 AM
To: mssms@lists.myitforum.com
Subject: [mssms] Report clocking. Used to work in 2007 but not in CB

HI,

This report works on smaller collections, but when I bump it up to all systems 
(with 5) systems it just runs for hours and hours and never ends.  It runs 
on collections with 7000 or so in them.

Is there something busted in it?  I basically want a row for every pc in the 
collection no matter what.

SELECT DISTINCT
 SYS.Name0, SYS.Client_Version0, 
SYS.Operating_System_Name_and0, SYS.Creation_Date0, 
v_GS_COMPUTER_SYSTEM.Model0, SYS.AD_Site_Name0,
 SYS.Distinguished_Name0 AS Expr1, 
MAX(v_RA_System_SystemOUName.System_OU_Name0) AS SystemOUName, SYS.User_Name0,
 v_R_User.Full_User_Name0, v_R_User.Mail0, 
v_R_User.employeeID0, v_R_User.department0, v_R_User.title0, @CollID AS 
CollectionID,
 SYS.Resource_Domain_OR_Workgr0, SYS.Active0, 
SYS.Client0
FROMv_R_System AS SYS FULL OUTER JOIN
 v_R_User ON v_R_User.User_Name0 = SYS.User_Name0 FULL 
OUTER JOIN
 v_GS_COMPUTER_SYSTEM ON 
v_GS_COMPUTER_SYSTEM.ResourceID = SYS.ResourceID INNER JOIN
 v_FullCollectionMembership AS fcm ON SYS.ResourceID = 
fcm.ResourceID INNER JOIN
 v_RA_System_SystemOUName ON SYS.ResourceID = 
v_RA_System_SystemOUName.ResourceID
WHERE(fcm.CollectionID = @CollID)
GROUP BY SYS.Name0, SYS.Client_Version0, SYS.Operating_System_Name_and0, 
SYS.Creation_Date0, v_GS_COMPUTER_SYSTEM.Model0, SYS.User_Name0,
 v_R_User.Full_User_Name0, v_R_User.Mail0, 
v_R_User.employeeID0, v_R_User.department0, v_R_User.title0, 
v_R_User.Distinguished_Name0,
 v_R_User.manager0, SYS.AD_Site_Name0, 
SYS.Distinguished_Name0, SYS.Resource_Domain_OR_Workgr0, SYS.Active0, 
SYS.Client0
ORDER BY SYS.Name0

[mssms] RE: SQL DB Issues - A primary site in CAS environ

[Garth Jones]

As I pointed out to you within the MS forums.

It is a bad idea to have two different troubleshooting tasks happening at the 
same time. Since you are already working with CSS you should talk to them about 
the restore option. They are best suited to ensure that you don't hit any road 
block. They are also better suited to ensure that your environment is healthy 
prior to reforming this task. And to Help with any testing to confirm that the 
envioment is healthy after the restore is done.

If you start today you will be done in a day or two.





Garth Jones
Chief Architect
Configuration Manager/SCCM Reporting<https://www.enhansoft.com/>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Miriyala, Vasu
Sent: Wednesday, July 26, 2017 8:38 AM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: SQL DB Issues - A primary site in CAS environ

MS are helping best with possible options, however time to resolve is expected 
longer than our client agrees to, hence checking around for alternate options
Thanks for your time. It helped

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of J v D
Sent: Wednesday, July 26, 2017 3:12 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] RE: SQL DB Issues - A primary site in CAS environ

Site, follow the same steps as if you would replace the siteserver 
hardware...at the restore option where you can refer to a SQL or SCCM backup 
you choose to restore from CAS.
There are a few blogsites around with steps but since MS is already working 
with you they can provide it as well..unless...they recommend something else.. 
:)

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Miriyala, Vasu
Sent: Wednesday, July 26, 2017 11:33 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] RE: SQL DB Issues - A primary site in CAS environ

Thanks JvD,
Does this help me restore SQL only, back to its good state or entire site ?  
What are the key steps in this approach

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of J v D
Sent: Wednesday, July 26, 2017 10:39 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] RE: SQL DB Issues - A primary site in CAS environ

Do a recovery of the primary from the CAS.

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Miriyala, Vasu
Sent: Wednesday, July 26, 2017 7:00 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] SQL DB Issues - A primary site in CAS environ

Hello,

SCCM 2012 latest CB environ, with a CAS and few primaries. One of primary has 
SQL issues where SRPOC and/or Tables aren't functioning well. PSS has been 
working on to fix SQL, however two weeks spent, two more weeks expected to 
clean a heavy corrupted table to be cleaned up. SQL DB of old instances not 
helpful to restore as most of old snapshot observed to have same problem. We 
have had SQL issues in the past, tried many work arounds, which I assume has 
corrupted some tables or SPROC or so on... HENCE

My question now is, is it possible to install a fresh SQL server instance on 
primary and get it going, with assumption of restore the site data from CAS, 
and Inventory, status messages etc. will come back again from clients...instead 
of waiting for two more week of troubleshooting ?

Thanks, Vasu
This message contains information that may be privileged or confidential and is 
the property of the Capgemini Group. It is intended only for the person to whom 
it is addressed. If you are not the intended recipient, you are not authorized 
to read, print, retain, copy, disseminate, distribute, or use this message or 
any part thereof. If you receive this message in error, please notify the 
sender immediately and delete all copies of this message.


This message contains information that may be privileged or confidential and is 
the property of the Capgemini Group. It is intended only for the person to whom 
it is addressed. If you are not the intended recipient, you are not authorized 
to read, print, retain, copy, disseminate, distribute, or use this message or 
any part thereof. If you receive this message in error, please notify the 
sender immediately and delete all copies of this message.


This message contains information that may be privileged or confidential and is 
the property of the Capgemini Group. It is intended only for the person to whom 
it is addressed. If you are not the intended recipient, you are not authorized 
to read, print, retain, copy, disseminate, distribute, or use this message or 
any part thereof. If you receive this m

[mssms] RE: SQL DB Issues - A primary site in CAS environ

[Garth Jones]

If you are already working with CSS, take ideas from the forums and mailing 
list is a bad idea. As the options might conflict with each other. You should 
discuss your issue with CSS directly.

I forget if you can report from a CAS in CM12 (you can in CMCB), but since you 
are talking to CSS it would be best to discuss this option and work with them 
to perform it.



Garth Jones
Chief Architect
Configuration Manager/SCCM Reporting<https://www.enhansoft.com/>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Miriyala, Vasu
Sent: Wednesday, July 26, 2017 1:00 AM
To: mssms@lists.myitforum.com
Subject: [mssms] SQL DB Issues - A primary site in CAS environ

Hello,

SCCM 2012 latest CB environ, with a CAS and few primaries. One of primary has 
SQL issues where SRPOC and/or Tables aren't functioning well. PSS has been 
working on to fix SQL, however two weeks spent, two more weeks expected to 
clean a heavy corrupted table to be cleaned up. SQL DB of old instances not 
helpful to restore as most of old snapshot observed to have same problem. We 
have had SQL issues in the past, tried many work arounds, which I assume has 
corrupted some tables or SPROC or so on... HENCE

My question now is, is it possible to install a fresh SQL server instance on 
primary and get it going, with assumption of restore the site data from CAS, 
and Inventory, status messages etc. will come back again from clients...instead 
of waiting for two more week of troubleshooting ?

Thanks, Vasu
This message contains information that may be privileged or confidential and is 
the property of the Capgemini Group. It is intended only for the person to whom 
it is addressed. If you are not the intended recipient, you are not authorized 
to read, print, retain, copy, disseminate, distribute, or use this message or 
any part thereof. If you receive this message in error, please notify the 
sender immediately and delete all copies of this message.

[mssms] RE: Compliance Reporting in SCCM 2012

[Garth Jones]

For the MOF edit, this is NOT something that you can added to your HW inventory.

This WMI class already exist on your primary site server and it is not meant 
for what you are looking for.



Garth Jones
Chief Architect
Configuration Manager/SCCM Reporting<https://www.enhansoft.com/>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Boseman, Marcia H - Raleigh, NC
Sent: Thursday, June 29, 2017 3:01 PM
To: mssms@lists.myitforum.com
Subject: [mssms] Compliance Reporting in SCCM 2012

Has anyone implemented the following or have recommendations on Compliance 
reporting?  If you have used the link below, please advise how you implemented 
the mof.

https://msdn.microsoft.com/en-us/library/hh458499.aspx

[mssms] RE: Hardware Inventory

[Garth Jones]

Keep in mind that the problem with SW inventory is the 4 hour timeout 
(runtime). Once the 4 hour time hits, everything the computer inventory is 
thrown away! Yes I said it is thrown away. The result will never be returned to 
CM. This allows for old data to get struck in the CM database and it also means 
that you might have clients with no results when you should.  Therefore it also 
means that you can't trust the data as you will never know if the data is still 
valid or has all computers.

On top of that while SW inventory is running, it will block all other inventory 
tasks (HW inv and Heartbeat), because SW inventory is a low priority task, it 
could take days for it to complete or hit the timeout.

So how do you inventory each of those? (Eg. Apache Tomcat, Apache Maven, 
Eclipse) To be honest, I have not looked for those recently, but why not use a 
CI for them? At least a CI will not stop the other inventory tasks, generally 
as CI will complete in a few seconds. My quick google search for Apache Tomcat  
suggest it runs a service, this is collected by HW inventory by default.  Will 
that do, I'm not sure. But I do know that run SW inventory with *.exe and/or 
*.dll on all hard drives will take forever to run. So you will need to review 
your SW data to ensure that it is correct.





Garth Jones
Chief Architect
Configuration Manager/SCCM Reporting<https://www.enhansoft.com/>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Edward Woo
Sent: Friday, June 23, 2017 5:48 PM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: Hardware Inventory

While SW inventory is basically a file inventory and the recommendation is to 
use HW inventory, how do you handle software that do not write data into 
Add/Remove Programs like open source software that are installed using ZIP 
files? (Eg. Apache Tomcat, Apache Maven, Eclipse, etc) Do you need to manually 
create CI for every application or is there a more automated way to determine 
what is present on the systems out there? (With SW inventory, I can just look 
for all systems with eclipse.exe and use that info to see how many instances of 
it is present and where they are presently stored.)

Thanks,

Edward

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Jason Sandys
Sent: Friday, June 23, 2017 11:18 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] RE: Hardware Inventory

Hardware inventory. Software Inventory in ConfigMgr is a file inventory and 
does not necessarily reflect actually installed software. If you need to know 
about explicit files on a system, like all .psts, then software inventory is 
great. For generic scans of all files though, it's not very efficient and has a 
high cost in terms of db space and client impact for not a lot of useful info. 
Configuration Items are usually also a much better choice as well.

J

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Mead, Renae (DTMB)
Sent: Friday, June 23, 2017 12:52 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] RE: Hardware Inventory

Thank you.  We currently have heartbeat discovery set to daily.  What do you 
use for SW inventory if not ConfigMgr?


From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones
Sent: Friday, June 23, 2017 9:09 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] RE: Hardware Inventory

In general, I recommend HW to be setup daily and SW inventory to be disabled, 
as it is useless! If SW is not disabled then set to every 14 days. BTW 
Heartbeat discovery I also recommend be set to daily too.

Keep in mind that ConfigMgr is NOT a CMDB.



Garth Jones
Chief Architect
Configuration Manager/SCCM Reporting<https://www.enhansoft.com/>

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Mead, Renae (DTMB)
Sent: Friday, June 23, 2017 8:55 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] Hardware Inventory

I'm curious how often everyone is running hardware inventory? We have about 
50,000 machines in our environment running hardware and software inventory 
every 4 days. We are getting rid of our asset management system and upper 
management wants ConfigMgr to replace it.

Thanks,
Renae Mead
DTMB IS OA Enterprise Services
mea...@michigan.gov<mailto:mea...@michigan.gov>
(517) 636-0761 Office
(517) 388-2737 Mobile

[mssms] RE: Hardware Inventory

[Garth Jones]

I don't use it at all, I avoid it alike the plague! I will use CI or HW 
inventory or anything else but it.

BTW, here is another blog post on the subject. 
https://www.enhansoft.com/blog/slow-software-inventory-cycle-in-sccm-2012





Garth Jones
Chief Architect
Configuration Manager/SCCM Reporting<https://www.enhansoft.com/>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Mead, Renae (DTMB)
Sent: Friday, June 23, 2017 1:52 PM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: Hardware Inventory

Thank you.  We currently have heartbeat discovery set to daily.  What do you 
use for SW inventory if not ConfigMgr?


From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones
Sent: Friday, June 23, 2017 9:09 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] RE: Hardware Inventory

In general, I recommend HW to be setup daily and SW inventory to be disabled, 
as it is useless! If SW is not disabled then set to every 14 days. BTW 
Heartbeat discovery I also recommend be set to daily too.

Keep in mind that ConfigMgr is NOT a CMDB.



Garth Jones
Chief Architect
Configuration Manager/SCCM Reporting<https://www.enhansoft.com/>

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Mead, Renae (DTMB)
Sent: Friday, June 23, 2017 8:55 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] Hardware Inventory

I'm curious how often everyone is running hardware inventory? We have about 
50,000 machines in our environment running hardware and software inventory 
every 4 days. We are getting rid of our asset management system and upper 
management wants ConfigMgr to replace it.

Thanks,
Renae Mead
DTMB IS OA Enterprise Services
mea...@michigan.gov<mailto:mea...@michigan.gov>
(517) 636-0761 Office
(517) 388-2737 Mobile

[mssms] RE: Hardware Inventory

[Garth Jones]

ConfigMgr Software Inventory should be called SW inventory. Instead it should 
be called File inventory. And it is slower than molasses. Hardware Inventory is 
what you should be using. This is where all the good stuff is, AI Data, 
Add/Remove programs. Etc..

Here are a couple of the blog I have written on the subject of SW inventory.
https://www.enhansoft.com/blog/how-do-you-determine-the-length-of-a-software-inventory-scan-cycle
https://www.enhansoft.com/blog/configuration-manager-and-software-inventory-proceed-with-caution






Garth Jones
Chief Architect
Configuration Manager/SCCM Reporting<https://www.enhansoft.com/>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Mead, Renae (DTMB)
Sent: Friday, June 23, 2017 1:49 PM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: Hardware Inventory

Thanks.

What are you using in place of Software Inventory? Third party software? Or 
just not collecting the data regularly?

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of David McSpadden
Sent: Friday, June 23, 2017 1:27 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] RE: Hardware Inventory

HW for the win once a day (but a sheepish 750 machines compared to you all.)
SW for a one off report like Internet Explorer inventory.  Seriously only ever 
use the SW inventory for a specific file name to get version.
Otherwise as most all will say.  SW inventory is useless.


From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Marable, Mike
Sent: Friday, June 23, 2017 9:29 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] RE: Hardware Inventory

Notice:  This email is from an outside source.  Please do not open any 
attachments, click on any hyperlinks, or respond without first confirming the 
authenticity of the email.
We have about 35,000 machines and we're running hardware inventory every 10 
hours.

Mike



From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Mead, Renae (DTMB)
Sent: Friday, June 23, 2017 8:55 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] Hardware Inventory

I'm curious how often everyone is running hardware inventory? We have about 
50,000 machines in our environment running hardware and software inventory 
every 4 days. We are getting rid of our asset management system and upper 
management wants ConfigMgr to replace it.

Thanks,
Renae Mead
DTMB IS OA Enterprise Services
mea...@michigan.gov<mailto:mea...@michigan.gov>
(517) 636-0761 Office
(517) 388-2737 Mobile



**
Electronic Mail is not secure, may not be read every day, and should not be 
used for urgent or sensitive issues


This e-mail and any files transmitted with it are property of Indiana Members 
Credit Union, are confidential, and are intended solely for the use of the 
individual or entity to whom this e-mail is addressed. If you are not one of 
the named recipient(s) or otherwise have reason to believe that you have 
received this message in error, please notify the sender and delete this 
message immediately from your computer. Any other use, retention, 
dissemination, forwarding, printing, or copying of this email is strictly 
prohibited.


Please consider the environment before printing this email.

[mssms] RE: Hardware Inventory

[Garth Jones]

Have you see Sherry's IE Mof edit to collect this via HW inventory?

Did you see that I will be creating a full SSRS report set for either IE 
inventory or .Net Inventory, for a giveaway next month? So make sure that you 
vote for the one you want.
https://www.enhansoft.com/blog/remember-to-help-choose-enhansofts-next-free-configmgr-report-for-the-month-of-july-2017





Garth Jones
Chief Architect
Configuration Manager/SCCM Reporting<https://www.enhansoft.com/>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of David McSpadden
Sent: Friday, June 23, 2017 1:27 PM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: Hardware Inventory

HW for the win once a day (but a sheepish 750 machines compared to you all.)
SW for a one off report like Internet Explorer inventory.  Seriously only ever 
use the SW inventory for a specific file name to get version.
Otherwise as most all will say.  SW inventory is useless.


From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Marable, Mike
Sent: Friday, June 23, 2017 9:29 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] RE: Hardware Inventory

Notice:  This email is from an outside source.  Please do not open any 
attachments, click on any hyperlinks, or respond without first confirming the 
authenticity of the email.

We have about 35,000 machines and we're running hardware inventory every 10 
hours.

Mike



From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Mead, Renae (DTMB)
Sent: Friday, June 23, 2017 8:55 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] Hardware Inventory

I'm curious how often everyone is running hardware inventory? We have about 
50,000 machines in our environment running hardware and software inventory 
every 4 days. We are getting rid of our asset management system and upper 
management wants ConfigMgr to replace it.

Thanks,
Renae Mead
DTMB IS OA Enterprise Services
mea...@michigan.gov<mailto:mea...@michigan.gov>
(517) 636-0761 Office
(517) 388-2737 Mobile



**
Electronic Mail is not secure, may not be read every day, and should not be 
used for urgent or sensitive issues


This e-mail and any files transmitted with it are property of Indiana Members 
Credit Union, are confidential, and are intended solely for the use of the 
individual or entity to whom this e-mail is addressed. If you are not one of 
the named recipient(s) or otherwise have reason to believe that you have 
received this message in error, please notify the sender and delete this 
message immediately from your computer. Any other use, retention, 
dissemination, forwarding, printing, or copying of this email is strictly 
prohibited.


Please consider the environment before printing this email.

[mssms] RE: Hardware Inventory

[Garth Jones]

In general, I recommend HW to be setup daily and SW inventory to be disabled, 
as it is useless! If SW is not disabled then set to every 14 days. BTW 
Heartbeat discovery I also recommend be set to daily too.

Keep in mind that ConfigMgr is NOT a CMDB.



Garth Jones
Chief Architect
Configuration Manager/SCCM Reporting<https://www.enhansoft.com/>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Mead, Renae (DTMB)
Sent: Friday, June 23, 2017 8:55 AM
To: mssms@lists.myitforum.com
Subject: [mssms] Hardware Inventory

I'm curious how often everyone is running hardware inventory? We have about 
50,000 machines in our environment running hardware and software inventory 
every 4 days. We are getting rid of our asset management system and upper 
management wants ConfigMgr to replace it.

Thanks,
Renae Mead
DTMB IS OA Enterprise Services
mea...@michigan.gov<mailto:mea...@michigan.gov>
(517) 636-0761 Office
(517) 388-2737 Mobile

[mssms] RE: Query assistance

[Garth Jones]

If you are in Ottawa, Ontario, I'm presenting on this topic starting at 6pm 
(aka 130 minutes from now) at the Microsoft office. :)

Otherwise, I will try to write this up tomorrow when I get back into the office 
tomorrow.

 Or/and you can see me at IT/Dev Connections in 
October, I'm doing two session there on ConfigMgr, SQL and Reporting.
http://devconnections.com/dc17/Public/SpeakerDetails.aspx?FromPage=Speakers.aspx=1136210

If you come to IT/Dev, let me know and I will get you a signed napkin from the 
famous but elusive Rod Trent!




Garth Jones
Chief Architect

www.Enhansoft.com<http://www.enhansoft.com/>
[Description: Description: 
cid:image001.jpg@01CC63FB.974F4EC0]<http://www.enhansoft.com/>
Enhancing Your Business
[Description: Description: Description: Description: Description: Description: 
Description: 
cid:image004.png@01CD5E19.F3C3A110]<http://www.enhansoft.com/blog>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image005.png@01CD5E19.F3C3A110]<https://twitter.com/enhansoft>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image006.jpg@01CD5E19.F3C3A110]<http://www.facebook.com/EnhansoftInc>[Description:
 Description: Description: Description: Description: Description: Description: 
Description: Description: Description: Description: Description: Description: 
Description: Description: Enhansoft's YouTube 
Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description: 
Description: Description: Description: Description: Description: 
cid:image007.png@01CD5E19.F3C3A110]<http://myitforum.com/myitforumwp/community/groups/enhansoft/>

Subscribe to Enhansoft's Newsletter!<http://www.enhansoft.com/register>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Enley, Carl
Sent: Wednesday, May 24, 2017 3:31 PM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: Query assistance

Garth thanks for taking the time to explain this to me.

I guess what I really want is a way (Sql or WQL) to select a collection of 
computers and from there output the computer name, primary user assigned to 
that device and their email address. I am surprised this is not natively 
possible from within the console as it seems that it would save a bunch of 
time. I am okay with either SSMS or creating SSRS report to get this done, I 
just don't have the expertise to start from scratch.

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones
Sent: Wednesday, May 24, 2017 10:10 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] RE: Query assistance

You can't take a SQL query and use it within the CM console, they are two 
different (SQL vs WQL) languages.

What you are asking to do make a lot more sense to do in SSMS or even a SSRS 
reporting than in CM console. The CM console will be almost impossible to do 
what you want.

Yes you can get the primary user (PU) or top console user (TCU) for every 
computer, I was just giving you a starting point. There are ton of SQL examples 
on the web for both TCU and PU.

I always recommend that you start with the basic details you want for you SQL 
query then add to your query until you are happy with it. As such, What exactly 
is the most basic details that you want (ignore email and TCP/PU for now), that 
is the query you should write in SSMS. Once you have that add TCP/PU, then 
email.




Garth Jones
Chief Architect

www.Enhansoft.com<http://www.enhansoft.com/>
[Description: Description: 
cid:image001.jpg@01CC63FB.974F4EC0]<http://www.enhansoft.com/>
Enhancing Your Business
[Description: Description: Description: Description: Description: Description: 
Description: 
cid:image004.png@01CD5E19.F3C3A110]<http://www.enhansoft.com/blog>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image005.png@01CD5E19.F3C3A110]<https://twitter.com/enhansoft>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image006.jpg@01CD5E19.F3C3A110]<http://www.facebook.com/EnhansoftInc>[Description:
 Description: Description: Description: Description: Description: Description: 
Description: Description: Description: Description: Description: Description: 
Description: Description: Enhansoft's YouTube 
Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description: 
Description: Description: Description: Description: Description: 
cid:image007.png@01CD5E19.F3C3A110]<http://myitforum.com/myitforumwp/community/groups/enhansoft/>

Subscribe to Enhansoft's Newsletter!<http://www.enhansoft.com/register>

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitfo

[mssms] RE: Query assistance

[Garth Jones]

You can't take a SQL query and use it within the CM console, they are two 
different (SQL vs WQL) languages.

What you are asking to do make a lot more sense to do in SSMS or even a SSRS 
reporting than in CM console. The CM console will be almost impossible to do 
what you want.

Yes you can get the primary user (PU) or top console user (TCU) for every 
computer, I was just giving you a starting point. There are ton of SQL examples 
on the web for both TCU and PU.

I always recommend that you start with the basic details you want for you SQL 
query then add to your query until you are happy with it. As such, What exactly 
is the most basic details that you want (ignore email and TCP/PU for now), that 
is the query you should write in SSMS. Once you have that add TCP/PU, then 
email.




Garth Jones
Chief Architect

www.Enhansoft.com<http://www.enhansoft.com/>
[Description: Description: 
cid:image001.jpg@01CC63FB.974F4EC0]<http://www.enhansoft.com/>
Enhancing Your Business
[Description: Description: Description: Description: Description: Description: 
Description: 
cid:image004.png@01CD5E19.F3C3A110]<http://www.enhansoft.com/blog>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image005.png@01CD5E19.F3C3A110]<https://twitter.com/enhansoft>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image006.jpg@01CD5E19.F3C3A110]<http://www.facebook.com/EnhansoftInc>[Description:
 Description: Description: Description: Description: Description: Description: 
Description: Description: Description: Description: Description: Description: 
Description: Description: Enhansoft's YouTube 
Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description: 
Description: Description: Description: Description: Description: 
cid:image007.png@01CD5E19.F3C3A110]<http://myitforum.com/myitforumwp/community/groups/enhansoft/>

Subscribe to Enhansoft's Newsletter!<http://www.enhansoft.com/register>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Enley, Carl
Sent: Wednesday, May 24, 2017 8:37 AM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: Query assistance

Thanks, excuse my ignorance but if I run the query directly in SQL manager I 
get accurate results. If I try to create a new query from the config mgr 
console I get a syntax is not correct error, am I missing something? I will be 
the first to admit that reporting and SQL are not my strong points. Also is it 
possible to list the users primary device in the results output?


[cid:image012.jpg@01D2D475.F1EF]


From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones
Sent: Wednesday, May 24, 2017 8:19 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] RE: Query assistance

The query will get you stated.


Select
   U.Full_User_Name0,
   Case
 When isnull(U.Mail0, 'n/a') = 'n/a' then 'n/a'
 when U.Mail0 = '' then 'n/a'
 else
 U.Mail0
   End as 'Email'
from
   dbo.v_R_User U


Take this query and build upon it, if you get stuck post what you have here 
with a short description of the problem you are having.



Garth Jones
Chief Architect

www.Enhansoft.com<http://www.enhansoft.com/>
[Description: Description: 
cid:image001.jpg@01CC63FB.974F4EC0]<http://www.enhansoft.com/>
Enhancing Your Business
[Description: Description: Description: Description: Description: Description: 
Description: 
cid:image004.png@01CD5E19.F3C3A110]<http://www.enhansoft.com/blog>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image005.png@01CD5E19.F3C3A110]<https://twitter.com/enhansoft>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image006.jpg@01CD5E19.F3C3A110]<http://www.facebook.com/EnhansoftInc>[Description:
 Description: Description: Description: Description: Description: Description: 
Description: Description: Description: Description: Description: Description: 
Description: Description: Enhansoft's YouTube 
Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description: 
Description: Description: Description: Description: Description: 
cid:image007.png@01CD5E19.F3C3A110]<http://myitforum.com/myitforumwp/community/groups/enhansoft/>

Subscribe to Enhansoft's Newsletter!<http://www.enhansoft.com/register>

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Enley, Carl
Sent: Wednesday, May 24, 2017 8:00 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] Query assistance

I need help writing a query that will allow me to pull 

[mssms] RE: Query assistance

[Garth Jones]

The query will get you stated.


Select
   U.Full_User_Name0,
   Case
 When isnull(U.Mail0, 'n/a') = 'n/a' then 'n/a'
 when U.Mail0 = '' then 'n/a'
 else
 U.Mail0
   End as 'Email'
from
   dbo.v_R_User U


Take this query and build upon it, if you get stuck post what you have here 
with a short description of the problem you are having.



Garth Jones
Chief Architect

www.Enhansoft.com<http://www.enhansoft.com/>
[Description: Description: 
cid:image001.jpg@01CC63FB.974F4EC0]<http://www.enhansoft.com/>
Enhancing Your Business
[Description: Description: Description: Description: Description: Description: 
Description: 
cid:image004.png@01CD5E19.F3C3A110]<http://www.enhansoft.com/blog>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image005.png@01CD5E19.F3C3A110]<https://twitter.com/enhansoft>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image006.jpg@01CD5E19.F3C3A110]<http://www.facebook.com/EnhansoftInc>[Description:
 Description: Description: Description: Description: Description: Description: 
Description: Description: Description: Description: Description: Description: 
Description: Description: Enhansoft's YouTube 
Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description: 
Description: Description: Description: Description: Description: 
cid:image007.png@01CD5E19.F3C3A110]<http://myitforum.com/myitforumwp/community/groups/enhansoft/>

Subscribe to Enhansoft's Newsletter!<http://www.enhansoft.com/register>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Enley, Carl
Sent: Wednesday, May 24, 2017 8:00 AM
To: mssms@lists.myitforum.com
Subject: [mssms] Query assistance

I need help writing a query that will allow me to pull the primary user and the 
mail0 attribute for each machine in a collection. I need to communicate with a 
group of users about an anticipated software update and it would be great if I 
could add all of the machines to a collection run a query against it to pull 
the email address for the primary device user. I could then just export the 
results and copy the email address into Outlook for the communication.

I do have the email address being discovered and UDA turned on and working, CM 
1702 if it matters.

Thanks

[mssms] RE: Compliance Reports for MS17-010

[Garth Jones]

This report might do what you are looking for. 
https://www.enhansoft.com/blog/software-update-details-is-may-2017s-free-configmgr-report


Garth Jones
Chief Architect

www.Enhansoft.com<http://www.enhansoft.com/>
[Description: Description: 
cid:image001.jpg@01CC63FB.974F4EC0]<http://www.enhansoft.com/>
Enhancing Your Business
[Description: Description: Description: Description: Description: Description: 
Description: 
cid:image004.png@01CD5E19.F3C3A110]<http://www.enhansoft.com/blog>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image005.png@01CD5E19.F3C3A110]<https://twitter.com/enhansoft>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image006.jpg@01CD5E19.F3C3A110]<http://www.facebook.com/EnhansoftInc>[Description:
 Description: Description: Description: Description: Description: Description: 
Description: Description: Description: Description: Description: Description: 
Description: Description: Enhansoft's YouTube 
Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description: 
Description: Description: Description: Description: Description: 
cid:image007.png@01CD5E19.F3C3A110]<http://myitforum.com/myitforumwp/community/groups/enhansoft/>

Subscribe to Enhansoft's Newsletter!<http://www.enhansoft.com/register>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Kent, Mark
Sent: Friday, May 12, 2017 4:35 PM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: Compliance Reports for MS17-010

I think I am in the same boat here...

Mark Kent
Manager, Client Systems Engineering
Technology Support Services
Resources for Information, Technology and Education (RITE)
http://rite.buffalostate.edu<http://rite.buffalostate.edu/>

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of ODONNELL Aaron M
Sent: Friday, May 12, 2017 4:24 PM
To: 'mssms@lists.myitforum.com' 
<mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>>
Subject: [mssms] Compliance Reports for MS17-010

So the big ransomware outbreak has MS17-010 on everyone's mind, and I've been 
asked to get a compliance report on this from SCCM. I haven't had to do this in 
a while so maybe I'm missing something obvious.

I'm using the Compliance 2 - Specific Software Update report to check for 
compliance on the March 2017 Security Monthly Quality Rollup (kb4012215) which 
is what we did push out in March, and all I get is a blank report when I put 
4012215 in the update filter. Same thing with 4015549 which is the April update 
that superseded the March one. Using 4019264 does get me results, which is the 
2017-05 May rollup, which of course superseded the previous two.

I'm guessing it's because the March and April updates were flagged as expired 
and one of the SCCM/WSUS cleanup processes removed the compliance data. If so, 
is there a way I can get a report on this just so I can show confirmation 
somewhere that we did in fact deploy this update and show compliance data on it?


Thanks,

Aaron O'Donnell

[mssms] RE: SQL reporting server upgrade needed for SCCM 1702

[Garth Jones]

If you upgraded, you should not lose your reports. So how exactly did you 
upgrade?

I have several blogs on how to back-up your SSRS reports, pick the best option 
for you.
https://www.enhansoft.com/blog/how-to-automatically-backup-configmgr-reports-using-sql-server-agent
https://www.enhansoft.com/blog/how-do-you-automatically-backup-configmgr-reports-using-afterbackup-bat
https://www.enhansoft.com/blog/how-do-you-backup-all-of-your-custom-configmgr-reports






From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Magnus Tveten
Sent: Tuesday, April 18, 2017 1:13 AM
To: mssms@lists.myitforum.com
Subject: [mssms] SQL reporting server upgrade needed for SCCM 1702

HI All,
I thought I was doing pretty good in getting things up to date 
however I realised that with 1702 my reporting server is on an unsupported OS, 
its on win2008r2
And from what I see it needs to be on Win2012r2.

I managed to mess up my backups when I did the Lab upgrade so I lost all of my 
custom reports.. (all three of them) But in Prod there are a ton more and I 
don't really want to lose those

What's the best way to go ahead and upgrade the reporting server ?

(best I guess really means : "least amount of impact to externals... such as 
people's links to reports... subscriptions ...done in a way that is 
supported..")

:)

One thought was to build new server, copy the reports over to it...
Take off the current reporting server
Shutdown old server.
Rename new to old and do all the things SQL needs to have done to it once you 
rename a server...
Then make it a reporting server point






Magnus Tveten

_

The information transmitted in this message and its attachments (if any) is 
intended
only for the person or entity to which it is addressed.
The message may contain confidential and/or privileged material. Any review,
retransmission, dissemination or other use of, or taking of any action in 
reliance
upon this information, by persons or entities other than the intended recipient 
is
prohibited.

If you have received this in error, please contact the sender and delete this 
e-mail
and associated material from any computer.

The intended recipient of this e-mail may only use, reproduce, disclose or 
distribute
the information contained in this e-mail and any attached files, with the 
permission
of the sender.

This message has been scanned for viruses.
_

[mssms] RE: SQL STD license with CB?

[Garth Jones]

Yes it is included. 

-Original Message-
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Brian McDonald
Sent: Monday, April 17, 2017 8:16 AM
To: mssms@lists.myitforum.com
Subject: [mssms] SQL STD license with CB?

GM,

Does anyone know if SQL Standard is included with SCCM Current Branch?

Thanks,

Brian

Sent from my iPhone

RE: [mssms] RE: SQL Query question

[Garth Jones]

:)

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Sherry Kissinger
Sent: Tuesday, April 4, 2017 12:37 PM
To: mssms@lists.myitforum.com
Subject: Re: [mssms] RE: SQL Query question

I was thinking Henry was just asking a "in general, which sql query s!cks 
less".  the fact that the subselect was using .net in there was just 
coincidence.

On Tue, Apr 4, 2017 at 7:57 AM, Garth Jones 
<ga...@enhansoft.com<mailto:ga...@enhansoft.com>> wrote:
Is there a reason why you are not using the MOF edit for this?

I'm in the process of restoring my lab so I can't check this but I don't 
think that OS like Win 10 and Server 16 listed .Net 4.5 in the installed 
software. This maybe only anniversary edition too.



From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>] 
On Behalf Of henry.wil...@sanofi.com<mailto:henry.wil...@sanofi.com>
Sent: Tuesday, April 4, 2017 8:33 AM

To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] RE: SQL Query question

Yes


Best regards / Cordialement

Henry E. WILSON
Technical Expert Engineer
Information Technology & Solutions
Infrastructure Management
Automation Services
55 Corporate Drive
Bridgewater, NJ 08807
TEL.: +1 908 981 3288<tel:(908)%20981-3288>
CELL.: +1 610 724 1169<tel:(610)%20724-1169>
FAX: +1 908 635 5858<tel:(908)%20635-5858>
System Center Technical 
Blog<http://wssamer.sanofi.com/ws/AutomationCenterProvTools/SCTechBlog/Lists/Posts/AllPosts.aspx>
 (for internal use only)
SCCM 2012 
Dashboard<http://xspw10w201w/Reports/Pages/Report.aspx?ItemPath=%2fUnRestricted+Reports%2fInfrastructure+Health+Status%2fConfigMgr+2012+Dashboard>
 (for internal use only)
Provisioning Tools & Lifecycle Sharepoint 
Site<http://wssamer.sanofi.com/ws/AutomationCenterProvTools/Documents/Forms/AllItems.aspx>
 (for internal use only)

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones
Sent: Tuesday, April 04, 2017 7:32 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] RE: SQL Query question

Hi Henry, what exactly is the goal? Is it to find all computers without .net 
4.5.2?

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of 
henry.wil...@sanofi.com<mailto:henry.wil...@sanofi.com>
Sent: April 4, 2017 6:16 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] SQL Query question

Hello SQL Guru's

We're having a discussion with some Admin's in Europe and I would like an 
opinion on 2 Collection queries looking for the same result:

Which one is more efficient?

Collection Query #1:
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.ResourceId not in
(
select SMS_R_System.ResourceId
from  SMS_R_System
inner join SMS_G_System_INSTALLED_SOFTWARE on 
SMS_G_System_INSTALLED_SOFTWARE.ResourceID = SMS_R_System.ResourceId
where SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName in
("Microsoft .NET Framework 4.5.2","Microsoft .NET Framework 4.6.1","Microsoft 
.NET Framework 4.6","Microsoft .NET Framework 4.6.2")
)
=
Collection Query #2:
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.resourceid NOT IN (SELECT sms_r_system.resourceid FROM 
sms_r_system
INNER JOIN sms_g_system_installed_software ON 
sms_g_system_installed_software.resourceid = sms_r_system.resourceid
WHERE sms_g_system_installed_software.arpdisplayname = "microsoft .net 
framework 4.5.2"
or sms_g_system_installed_software.arpdisplayname = "microsoft .net framework 
4.6.1"
or sms_g_system_installed_software.arpdisplayname = "microsoft .net framework 
4.6"
or sms_g_system_installed_software.arpdisplayname = "microsoft .net framework 
4.6.2"
==

A DCM has also been mentioned to achieve the same result.

Comments or recommendations?

Thanks

Best regards / Cordialement

Henry E. WILSON
Technical Expert Engineer
Information Technology & Solutions
Infrastructure Management
Automation Services
55 Corporate Drive
Bridgewater, NJ 08807
TEL.: +1 908 981 3288<tel:(908)%20981-3288>
CELL.: +1 610 724 1169<tel:(610)%20724-1169>
FAX: +1 908 635 5858<tel:(908)%20635-585

[mssms] RE: SQL Query question

[Garth Jones]

Is there a reason why you are not using the MOF edit for this?

I'm in the process of restoring my lab so I can't check this but I don't 
think that OS like Win 10 and Server 16 listed .Net 4.5 in the installed 
software. This maybe only anniversary edition too.



From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of henry.wil...@sanofi.com
Sent: Tuesday, April 4, 2017 8:33 AM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: SQL Query question

Yes


Best regards / Cordialement

Henry E. WILSON
Technical Expert Engineer
Information Technology & Solutions
Infrastructure Management
Automation Services
55 Corporate Drive
Bridgewater, NJ 08807
TEL.: +1 908 981 3288
CELL.: +1 610 724 1169
FAX: +1 908 635 5858
[cid:image001.jpg@01D2AD21.74742360]
System Center Technical 
Blog<http://wssamer.sanofi.com/ws/AutomationCenterProvTools/SCTechBlog/Lists/Posts/AllPosts.aspx>
 (for internal use only)
SCCM 2012 
Dashboard<http://xspw10w201w/Reports/Pages/Report.aspx?ItemPath=%2fUnRestricted+Reports%2fInfrastructure+Health+Status%2fConfigMgr+2012+Dashboard>
 (for internal use only)
Provisioning Tools & Lifecycle Sharepoint 
Site<http://wssamer.sanofi.com/ws/AutomationCenterProvTools/Documents/Forms/AllItems.aspx>
 (for internal use only)

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones
Sent: Tuesday, April 04, 2017 7:32 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] RE: SQL Query question

Hi Henry, what exactly is the goal? Is it to find all computers without .net 
4.5.2?

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of 
henry.wil...@sanofi.com<mailto:henry.wil...@sanofi.com>
Sent: April 4, 2017 6:16 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] SQL Query question

Hello SQL Guru's

We're having a discussion with some Admin's in Europe and I would like an 
opinion on 2 Collection queries looking for the same result:

Which one is more efficient?

Collection Query #1:
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.ResourceId not in
(
select SMS_R_System.ResourceId
from  SMS_R_System
inner join SMS_G_System_INSTALLED_SOFTWARE on 
SMS_G_System_INSTALLED_SOFTWARE.ResourceID = SMS_R_System.ResourceId
where SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName in
("Microsoft .NET Framework 4.5.2","Microsoft .NET Framework 4.6.1","Microsoft 
.NET Framework 4.6","Microsoft .NET Framework 4.6.2")
)
=
Collection Query #2:
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.resourceid NOT IN (SELECT sms_r_system.resourceid FROM 
sms_r_system
INNER JOIN sms_g_system_installed_software ON 
sms_g_system_installed_software.resourceid = sms_r_system.resourceid
WHERE sms_g_system_installed_software.arpdisplayname = "microsoft .net 
framework 4.5.2"
or sms_g_system_installed_software.arpdisplayname = "microsoft .net framework 
4.6.1"
or sms_g_system_installed_software.arpdisplayname = "microsoft .net framework 
4.6"
or sms_g_system_installed_software.arpdisplayname = "microsoft .net framework 
4.6.2"
==

A DCM has also been mentioned to achieve the same result.

Comments or recommendations?

Thanks

Best regards / Cordialement

Henry E. WILSON
Technical Expert Engineer
Information Technology & Solutions
Infrastructure Management
Automation Services
55 Corporate Drive
Bridgewater, NJ 08807
TEL.: +1 908 981 3288
CELL.: +1 610 724 1169
FAX: +1 908 635 5858
[cid:image002.jpg@01D2AD21.74742360]
System Center Technical 
Blog<http://wssamer.sanofi.com/ws/AutomationCenterProvTools/SCTechBlog/Lists/Posts/AllPosts.aspx>
 (for internal use only)
SCCM 2012 
Dashboard<https://urldefense.proofpoint.com/v2/url?u=http-3A__xspw10w201w_Reports_Pages_Report.aspx-3FItemPath-3D-252fUnRestricted-26-2343-3BReports-252fInfrastructure-26-2343-3BHealth-26-2343-3BStatus-252fConfigMgr-26-2343-3B2012-26-2343-3BDashboard=DQMFAg=Dbf9zoswcQ-CRvvI7VX5j3HvibIuT3ZiarcKl5qtMPo=rYU1OkDK6KGNCD3HQmVUxzwASyVld-wfgoG00ci6xjA=MMFkG-9PwzSKzcY5ZyvS_IAhrJY9YN2NUUSFFLHMgAc=YEfQW7Q-RoYf6tErPTwoZiC7byWKjKLfFhVaDQdT2zY=>
 (for internal use only)
Provisioning Tools & Lifecycle Sharepoint 
Site<http://wssamer.sanofi.com/ws/AutomationCenterProvTools/Documents/Forms/AllItems.aspx>
 (for internal use only)

[mssms] RE: SQL Query question

[Garth Jones]

Hi Henry, what exactly is the goal? Is it to find all computers without .net 
4.5.2?

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of henry.wil...@sanofi.com
Sent: April 4, 2017 6:16 AM
To: mssms@lists.myitforum.com
Subject: [mssms] SQL Query question

Hello SQL Guru's

We're having a discussion with some Admin's in Europe and I would like an 
opinion on 2 Collection queries looking for the same result:

Which one is more efficient?

Collection Query #1:
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.ResourceId not in
(
select SMS_R_System.ResourceId
from  SMS_R_System
inner join SMS_G_System_INSTALLED_SOFTWARE on 
SMS_G_System_INSTALLED_SOFTWARE.ResourceID = SMS_R_System.ResourceId
where SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName in
("Microsoft .NET Framework 4.5.2","Microsoft .NET Framework 4.6.1","Microsoft 
.NET Framework 4.6","Microsoft .NET Framework 4.6.2")
)
=
Collection Query #2:
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.resourceid NOT IN (SELECT sms_r_system.resourceid FROM 
sms_r_system
INNER JOIN sms_g_system_installed_software ON 
sms_g_system_installed_software.resourceid = sms_r_system.resourceid
WHERE sms_g_system_installed_software.arpdisplayname = "microsoft .net 
framework 4.5.2"
or sms_g_system_installed_software.arpdisplayname = "microsoft .net framework 
4.6.1"
or sms_g_system_installed_software.arpdisplayname = "microsoft .net framework 
4.6"
or sms_g_system_installed_software.arpdisplayname = "microsoft .net framework 
4.6.2"
==

A DCM has also been mentioned to achieve the same result.

Comments or recommendations?

Thanks

Best regards / Cordialement

Henry E. WILSON
Technical Expert Engineer
Information Technology & Solutions
Infrastructure Management
Automation Services
55 Corporate Drive
Bridgewater, NJ 08807
TEL.: +1 908 981 3288
CELL.: +1 610 724 1169
FAX: +1 908 635 5858
[cid:image001.jpg@01D2AD15.11914FE0]
System Center Technical 
Blog
 (for internal use only)
SCCM 2012 
Dashboard
 (for internal use only)
Provisioning Tools & Lifecycle Sharepoint 
Site
 (for internal use only)

[mssms] RE: Query for users with multiple primary devices

[Garth Jones]

This should do the trick.

SELECT
   UMR.MachineResourceID,
   UMR.MachineResourceName,
   UMR.UniqueUserName,
   U.Mail0
FROM
   dbo.v_R_User U
   JOIN dbo.v_UserMachineRelationship UMR ON UMR.UniqueUserName = 
U.Unique_User_Name0
   join (SELECT UMR.UniqueUserName as 'UniqueUserName' FROM 
dbo.v_UserMachineRelationship UMR group by UMR.UniqueUserName Having Count(*) 
>1) MT1 on MT1.UniqueUserName =  UMR.UniqueUserName


From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Enley, Carl
Sent: Thursday, March 30, 2017 3:28 PM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: Query for users with multiple primary devices

You could use this and just filter excel to show the duplicates in the name 
field?


SELECT UMR.MachineResourceID, UMR.MachineResourceName, UMR.UniqueUserName, Mail0
FROM v_R_User U
JOIN v_UserMachineRelationship UMR ON UMR.UniqueUserName = U.Unique_User_Name0

I also believe there is a built in report where you can specify a collection 
and the number of UDA relationships > greater than 1 for example.


From: listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Beardsley, James
Sent: Thursday, March 30, 2017 1:02 PM
To: mssms@lists.myitforum.com
Subject: [mssms] Query for users with multiple primary devices

Anyone have a SQL query that'll show me all users with more than one primary 
device assigned to them through UDA?

Thanks,
James



Confidentiality Notice: This e-mail is intended only for the addressee named 
above. It contains information that is privileged, confidential or otherwise 
protected from use and disclosure. If you are not the intended recipient, you 
are hereby notified that any review, disclosure, copying, or dissemination of 
this transmission, or taking of any action in reliance on its contents, or 
other use is strictly prohibited. If you have received this transmission in 
error, please reply to the sender listed above immediately and permanently 
delete this message from your inbox. Thank you for your cooperation.

[mssms] RE: SQL Query question / best practice

[Garth Jones]

Before making any suggestions, I have several questions


1.  What version of CM are you using?

2.  Do you use RBA? Aka will queries need to be RBA compliant?

3.  What version of SQL are you using?



From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Enley, Carl
Sent: Wednesday, March 1, 2017 9:45 AM
To: mssms@lists.myitforum.com
Subject: [mssms] SQL Query question / best practice

I am curious is anyone has any thoughts / suggestions surrounding 3rd party 
applications / tools running queries directly against the SCCM SQL database.

In my organization depending upon the company we have a few different asset 
management systems some are home brewed and others are 3rd party (manage 
engine) vendors. One of our biggest challenges is keeping all of our inventory 
/ asset management systems in "sync" so to speak. I have been approached by a 
few different departments / companies that would like to run queries directly 
against the SCCM SQL instance rather than use any type of built in reports / 
queries. They would like to automate the export of client information in their 
home grown tool without changing their process to include running canned 
reports out of the console or website. I offered to provide subscriptions to 
those reports they feel would be valuable but was told it would require a 
change to their current process they were not prepared to make.

So my thought is it should be no problem to provide them read only access to 
the database but my real concern is surrounding performance. I don't want 
someone running a poorly written SQL query against the database and possibly 
slowing down the system speed. When I suggested this could possibly happen I 
was assured by the developers that they are very experienced in writing SQL 
queries and this would not happenyadda, yadda, yadda.


Thanks for any suggestions.

[mssms] RE: SQL considerations when renaming site server as part of OS upgrade

[Garth Jones]

I agree. Avoiding installing SQL until after the computer is renamed is the 
best option.


From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Jason Sandys
Sent: Tuesday, February 28, 2017 9:26 AM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: SQL considerations when renaming site server as part of OS 
upgrade

Or simply don't install SQL Server until after you've renamed the system. It 
doesn't take that long to install SQL Server and some downtime is unavoidable 
with a site backup and restore.

J

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones
Sent: Monday, February 27, 2017 5:00 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] RE: SQL considerations when renaming site server as part of OS 
upgrade

Yes.. there are several steps that need to be done.
https://www.enhansoft.com/blog/how-to-rename-a-windows-server-when-sql-server-and-wsus-are-already-installed


From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Corkill, Daniel
Sent: Monday, February 27, 2017 5:44 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] SQL considerations when renaming site server as part of OS 
upgrade

I'm currently planning to migrate our site server to Server 2016 from 2008 R2 
by building up a new box and doing a site restore. I'm building up the new box 
with a temp name and IP and prior to the CM installation I will turn off the 
old box and rename the new box to match. I'm not sure how SQL will go - do I 
need to do anything with it after renaming the server? (SQL Server 2012 SP3).

Daniel.




*

The contents of this email message and any attachments are intended only for 
the addressee and may be confidential, private or the subject of copyright. If 
you have received this email in error please notify Logan City Council, by 
replying to the sender or calling +61 7 3412 3412  and delete all copies of the 
e-mail and any attachments.



To view Logan City Council's Privacy Collection Notice, please visit 
www.logan.qld.gov.au<http://www.logan.qld.gov.au> or click on the following 
link http://www.logan.qld.gov.au/home/terms-of-use.

[mssms] RE: SQL considerations when renaming site server as part of OS upgrade

[Garth Jones]

Yes.. there are several steps that need to be done.
https://www.enhansoft.com/blog/how-to-rename-a-windows-server-when-sql-server-and-wsus-are-already-installed


From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Corkill, Daniel
Sent: Monday, February 27, 2017 5:44 PM
To: mssms@lists.myitforum.com
Subject: [mssms] SQL considerations when renaming site server as part of OS 
upgrade

I'm currently planning to migrate our site server to Server 2016 from 2008 R2 
by building up a new box and doing a site restore. I'm building up the new box 
with a temp name and IP and prior to the CM installation I will turn off the 
old box and rename the new box to match. I'm not sure how SQL will go - do I 
need to do anything with it after renaming the server? (SQL Server 2012 SP3).

Daniel.




*

The contents of this email message and any attachments are intended only for 
the addressee and may be confidential, private or the subject of copyright. If 
you have received this email in error please notify Logan City Council, by 
replying to the sender or calling +61 7 3412 3412  and delete all copies of the 
e-mail and any attachments.



To view Logan City Council's Privacy Collection Notice, please visit 
www.logan.qld.gov.au or click on the following 
link http://www.logan.qld.gov.au/home/terms-of-use.

[mssms] RE: Changing permissions on SQL views

[Garth Jones]

Hi Daniel,

So there is an DB roles called smschm_user, which has select rights to "all" 
views within CM db. I put quote around the "all" because it is only on the 
views that should be query by reporting. if your view doesn't have this right 
then there is likely another view that you should be using instead. Of course 
db_datareader works too.



From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Daniel Ratliff
Sent: Tuesday, January 10, 2017 1:34 PM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: Changing permissions on SQL views

Just granting a service account view rights.

The justification is that they didn't want to grant rights to the entire DB, 
just this one view.

Daniel Ratliff

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones
Sent: Tuesday, January 10, 2017 1:15 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] RE: Changing permissions on SQL views

What are you trying to do? Most of the views already have a db role that will 
allow you to select from the view.



From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Daniel Ratliff
Sent: Tuesday, January 10, 2017 12:09 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] Changing permissions on SQL views

Just found out the 1610 upgrade wiped some custom permissions we had on 
v_package in our TEST and QA environments.

Is it supported to modify SQL view permissions?

If not, should we be settings permissions a different way, on the DB itself 
instead?

If it is, should we open a uservoice request to backup/restore view permissions?

Thanks!

Daniel Ratliff
Technology Architect | Client Innovation Solutions
Information Technology Infrastructure (ITI)

Humana
123 E. Main St. | Louisville, KY, 40202

T 502.476.9976
dratl...@humana.com<mailto:dratl...@humana.com>


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.



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: Changing permissions on SQL views

[Garth Jones]

What are you trying to do? Most of the views already have a db role that will 
allow you to select from the view.



From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Daniel Ratliff
Sent: Tuesday, January 10, 2017 12:09 PM
To: mssms@lists.myitforum.com
Subject: [mssms] Changing permissions on SQL views

Just found out the 1610 upgrade wiped some custom permissions we had on 
v_package in our TEST and QA environments.

Is it supported to modify SQL view permissions?

If not, should we be settings permissions a different way, on the DB itself 
instead?

If it is, should we open a uservoice request to backup/restore view permissions?

Thanks!

Daniel Ratliff
Technology Architect | Client Innovation Solutions
Information Technology Infrastructure (ITI)

Humana
123 E. Main St. | Louisville, KY, 40202

T 502.476.9976
dratl...@humana.com


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.

RE: [mssms] Query machines without a number

[Garth Jones]

Yes but sometimes it can’t be helped.

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Daniel Ratliff
Sent: Wednesday, January 4, 2017 3:02 PM
To: mssms@lists.myitforum.com
Subject: RE: [mssms] Query machines without a number

Isn’t that a bad query regarding performance? Not like and double wildcards?

Daniel Ratliff

From: listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Jason Sandys
Sent: Wednesday, January 04, 2017 2:03 PM
To: mssms@lists.myitforum.com
Subject: RE: [mssms] Query machines without a number

This should work:

SELECT name
FROM SMS_R_System
WHERE name not like ‘%[0123456789]%’

(replace the smart single quotes above with normal single quotes)

From: listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Daniel Ratliff
Sent: Wednesday, January 4, 2017 11:19 AM
To: mssms@lists.myitforum.com
Subject: RE: [mssms] Query machines without a number

The second use, either use a subselect query of machines with numbers, or 
create a collection of them and use an exclude rule.

Daniel Ratliff

From: listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Adam Juelich
Sent: Wednesday, January 04, 2017 12:11 PM
To: mssms@lists.myitforum.com
Subject: [mssms] Query machines without a number

Hello Everyone,

I have a unique scenario here.  The environment I inherited happens to have 
it's AD OU structure laid out in a way where Student/Staff devices are not 
separated.  In order to target Staff machines I could leverage UAC but there 
are some issues and limitations there that I'd like to hold off on.  Usage 
assignment won't work when machines are new, having the user choose the device 
can't prevent them from choosing multiple devices (licensing), manual 
assignment would take a long time, and I wouldn't know where to start in terms 
of creating a good CSV to import.

The only differential variable I can find between Student/Staff machine naming 
is the fact that staff machines have no numbers in them.  Is there a way I can 
do a query based on computer names without a number?  Or should I create 
collections for machines starting with a number and then use those as 
exclusions?

Maybe I'm overthinking it

Thanks!


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.



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: SCCM Query for Directory Existence

[Garth Jones]

IMO the best way to inventory this is to use a CI which detect if the 
application is installed or not. Then you can create a query on the results.

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Matt Gerding
Sent: Wednesday, January 4, 2017 11:49 AM
To: mssms@lists.myitforum.com
Subject: [mssms] SCCM Query for Directory Existence

Our company uses a 3rd party logistics application that doesn't display in 
add/remove programs once it's installed. When you try to verify the 
applications that are installed on a particular system via resource explorer, 
or via report, it doesn't list the application.

Is there a custom query I can run to report all devices where a specific 
directory exists?

Regards,

Matthew Gerding
Information Technology
Centurion Medical Products
517.540.1618
www.centurionmp.com
*
PATIENT CARE WITHOUT COMPROMISE(tm)

[mssms] RE: Recommended site server drive layout

[Garth Jones]

This is one of those questions. Unless you have control of the physical disks 
that your VM will access, then IMO, you should only have two drives.

C:\ OS only
D:\ Everything else

If you do have control of the physical disks then it is a question of how many 
computers you manage and what you have available to you with respect to 
physical disks.



From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of HELMS, DAVID C
Sent: Friday, December 16, 2016 10:03 AM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: Recommended site server drive layout

I was looking at this information when designing the drive configuration for 
our environment.  Our stuff is all VMware and connected to VMAX storage so I 
don't think it's necessary for us to create all these drives.   If that's a 
wrong assessment, I'd like to hear?

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones
Sent: Friday, December 16, 2016 9:48 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] RE: Recommended site server drive layout

***This is an EXTERNAL email. Please do not click on a link or open any 
attachments unless you are confident it is from a trusted source.


The first question, will it be a physical or virtual server?


From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Corkill, Daniel
Sent: Thursday, December 15, 2016 11:36 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] Recommended site server drive layout

I'm building a new site server to migrate from our existing Server 2008 R2 box. 
For a bit of context this is a stand-alone primary site with a max of 2500 
clients. I've never been happy with the current drive layout and am using this 
as an opportunity to review. So far I've found these two:

The Microsoft layout from the their recommended hardware page - 
https://docs.microsoft.com/en-us/sccm/core/plan-design/configs/recommended-hardware

Logical Drive

Purpose

C:

OS

E:

CM + SQL

F:

DB

G:

Log files

H:

TempDB + log files

I:

Content lib



Steve Thompson's layout - 
https://stevethompsonmvp.wordpress.com/2016/07/25/installing-and-configuring-sql-server-for-configuration-manager/

Logical Drive

Purpose

C:

OS

E:

CM + SQL + DB

F:

Log files incl. TempDB log

G:

Content lib

T:

Temp DB


Note I've modified Steve's layout somewhat as I don't want separate drives for 
backups and the pagefile at this time.

I don't mind either way I was just curious if you have any recommendations. I 
will probably lean towards Microsoft's layout purely because it's the official 
guidance.




*

The contents of this email message and any attachments are intended only for 
the addressee and may be confidential, private or the subject of copyright. If 
you have received this email in error please notify Logan City Council, by 
replying to the sender or calling +61 7 3412 3412  and delete all copies of the 
e-mail and any attachments.



To view Logan City Council's Privacy Collection Notice, please visit 
www.logan.qld.gov.au<http://www.logan.qld.gov.au> or click on the following 
link http://www.logan.qld.gov.au/home/terms-of-use.

[mssms] RE: Recommended site server drive layout

[Garth Jones]

The first question, will it be a physical or virtual server?


From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Corkill, Daniel
Sent: Thursday, December 15, 2016 11:36 PM
To: mssms@lists.myitforum.com
Subject: [mssms] Recommended site server drive layout

I'm building a new site server to migrate from our existing Server 2008 R2 box. 
For a bit of context this is a stand-alone primary site with a max of 2500 
clients. I've never been happy with the current drive layout and am using this 
as an opportunity to review. So far I've found these two:

The Microsoft layout from the their recommended hardware page - 
https://docs.microsoft.com/en-us/sccm/core/plan-design/configs/recommended-hardware

Logical Drive

Purpose

C:

OS

E:

CM + SQL

F:

DB

G:

Log files

H:

TempDB + log files

I:

Content lib



Steve Thompson's layout - 
https://stevethompsonmvp.wordpress.com/2016/07/25/installing-and-configuring-sql-server-for-configuration-manager/

Logical Drive

Purpose

C:

OS

E:

CM + SQL + DB

F:

Log files incl. TempDB log

G:

Content lib

T:

Temp DB


Note I've modified Steve's layout somewhat as I don't want separate drives for 
backups and the pagefile at this time.

I don't mind either way I was just curious if you have any recommendations. I 
will probably lean towards Microsoft's layout purely because it's the official 
guidance.




*

The contents of this email message and any attachments are intended only for 
the addressee and may be confidential, private or the subject of copyright. If 
you have received this email in error please notify Logan City Council, by 
replying to the sender or calling +61 7 3412 3412  and delete all copies of the 
e-mail and any attachments.



To view Logan City Council's Privacy Collection Notice, please visit 
www.logan.qld.gov.au or click on the following 
link http://www.logan.qld.gov.au/home/terms-of-use.

[mssms] RE: Asset Intelligence and Software Inventory

[Garth Jones]

It is any report that use recently used applications data. SWM has to be turn 
on in order to collect this data.


From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Corkill, Daniel
Sent: Thursday, December 15, 2016 1:49 AM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: Asset Intelligence and Software Inventory

I wasn't aware of this. We use AI but don't have SM enabled. What reports don't 
work?

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones
Sent: Thursday, 15 December 2016 5:00 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] RE: Asset Intelligence and Software Inventory

IMO yes you should have both turn on, even in CM12. Note that for AI report to 
work correctly, you only need SWM enabled with no rules defined for it.


From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Kent, Mark
Sent: Wednesday, December 14, 2016 12:22 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] RE: Asset Intelligence and Software Inventory

There are some AI reports that require SW Metering to be turned on as well.  
And we know how good SW metering is in SCCM...lol.

We've had metering and AI turned off for some time in 2012, we are moving to 
SCCM CB next week so I've been wondering whether to enable this stuff yet again.

Mark Kent
Manager, Client Systems Engineering
Technology Support Services
Resources for Information, Technology and Education (RITE)
http://rite.buffalostate.edu<http://rite.buffalostate.edu/>

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones
Sent: Wednesday, December 14, 2016 10:49 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] RE: Asset Intelligence and Software Inventory

I recommend turning off SW inv., it IMO is useless.

Be aware that although the AI is good, Not everything listed within ARP will be 
found within AI classes.


From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Kent, Mark
Sent: Wednesday, December 14, 2016 10:26 AM
To: 'mssms@lists.myitforum.com' 
<mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>>
Subject: [mssms] Asset Intelligence and Software Inventory

Just curious if folks are still using these two items or not bothering.

Mark Kent
Manager, Client Systems Engineering
Technology Support Services
Resources for Information, Technology and Education (RITE)
http://rite.buffalostate.edu<http://rite.buffalostate.edu/>









*

The contents of this email message and any attachments are intended only for 
the addressee and may be confidential, private or the subject of copyright. If 
you have received this email in error please notify Logan City Council, by 
replying to the sender or calling +61 7 3412 3412  and delete all copies of the 
e-mail and any attachments.



To view Logan City Council's Privacy Collection Notice, please visit 
www.logan.qld.gov.au<http://www.logan.qld.gov.au> or click on the following 
link http://www.logan.qld.gov.au/home/terms-of-use.

[mssms] RE: Asset Intelligence and Software Inventory

[Garth Jones]

IMO yes you should have both turn on, even in CM12. Note that for AI report to 
work correctly, you only need SWM enabled with no rules defined for it.


From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Kent, Mark
Sent: Wednesday, December 14, 2016 12:22 PM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: Asset Intelligence and Software Inventory

There are some AI reports that require SW Metering to be turned on as well.  
And we know how good SW metering is in SCCM...lol.

We've had metering and AI turned off for some time in 2012, we are moving to 
SCCM CB next week so I've been wondering whether to enable this stuff yet again.

Mark Kent
Manager, Client Systems Engineering
Technology Support Services
Resources for Information, Technology and Education (RITE)
http://rite.buffalostate.edu<http://rite.buffalostate.edu/>

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones
Sent: Wednesday, December 14, 2016 10:49 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] RE: Asset Intelligence and Software Inventory

I recommend turning off SW inv., it IMO is useless.

Be aware that although the AI is good, Not everything listed within ARP will be 
found within AI classes.


From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Kent, Mark
Sent: Wednesday, December 14, 2016 10:26 AM
To: 'mssms@lists.myitforum.com' 
<mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>>
Subject: [mssms] Asset Intelligence and Software Inventory

Just curious if folks are still using these two items or not bothering.

Mark Kent
Manager, Client Systems Engineering
Technology Support Services
Resources for Information, Technology and Education (RITE)
http://rite.buffalostate.edu<http://rite.buffalostate.edu/>

[mssms] RE: Asset Intelligence and Software Inventory

[Garth Jones]

I recommend turning off SW inv., it IMO is useless.

Be aware that although the AI is good, Not everything listed within ARP will be 
found within AI classes.


From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Kent, Mark
Sent: Wednesday, December 14, 2016 10:26 AM
To: 'mssms@lists.myitforum.com' 
Subject: [mssms] Asset Intelligence and Software Inventory

Just curious if folks are still using these two items or not bothering.

Mark Kent
Manager, Client Systems Engineering
Technology Support Services
Resources for Information, Technology and Education (RITE)
http://rite.buffalostate.edu

[mssms] RE: software inventory for all file extentions?

[Garth Jones]

SW inventory is not the tool to do this. There is no guarantee that it will 
ever complete or send results to you, as such you can't trust the results. 
However I would suggest creating a CI for this and having the CI run daily 
().  Anyone with those file type will be deem non-compliant and therefore 
are fairly easy to track down. The trick is to write your CI so that it will 
not overly impact the end users. This will take time and effort to complete.



From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Justin P. White
Sent: Tuesday, December 13, 2016 9:11 AM
To: mssms@lists.myitforum.com
Subject: [mssms] software inventory for all file extentions?

Ive been getting requests from my security team to detect certain file 
extentions with sccm to hunt down infected computers

Out of curiosity have any of you guys done a software inventory and included a 
*.* to scan all file types? I haven't done so and wanted to learn anyone's 
experiences with doing that, or if its as terrible as an idea I've come up with 
so far :)

Justin P. White
DAK Americas LLC Cooper River Site
Technical Specialist
(843) 797-9190 Work
(843) 709-0152 Cell
jpwh...@dakamericas.com
3350 Cypress Gardens Road
Moncks Corner, SC 29461



This message and its attachments may contain privileged, confidential or 
copyrighted information property of the sender. The information is intended 
only for the exclusive use of its intended recipient unless otherwise stated by 
the sender. Any interception, unauthorized review, forwarding, printing, 
copying, distributing, or using such information and its attachments is 
strictly prohibited and may be unlawful. This message and its attachments 
should not be revealed to unauthorized people. If you are not the intended 
recipient of this message and its attachments, you are hereby notified that you 
received this e-mail in error, and that any review, dissemination, distribution 
or copying of this e-mail and any attachment is strictly prohibited. If you 
have received this e-mail, attachments or both in error, please contact the 
sender and delete this message and its attachments from your computer and 
systems without retaining a copy. The sender takes no responsibility for any 
unauthorized reliance on this message. The content of this communication may be 
subject to export laws, including the U.S. Export Administration regulations 
and Mexican Export Administration regulations. Diversion contrary to any 
applicable laws is prohibited. This message is not intended as an offer, or 
acceptance, or amendment of a contract.

Este mensaje y sus anexos pueden contener información confidencial o protegida 
por derechos de autor, propiedad del emisor. La información es solo para el uso 
exclusivo del destinatario (a menos que el emisor especifique lo contrario). 
Cualquier intercepción, revisión, re-envío, impresión, copia, distribución o 
uso de dicha información y sus anexos sin previa autorización está 
estrictamente prohibido y podría constituir una conducta ilegal. Este mensaje y 
sus anexos no se deberán revelar a personas no autorizadas. Si usted no es el 
destinatario de este mensaje ni de sus anexos, se le informa a través de este 
medio que ha recibido este mensaje por error, y que cualquier revisión, 
difusión, distribución o copia de este mensaje o sus anexos está estrictamente 
prohibida. Si usted ha recibido este correo, sus anexos o ambos por error se le 
solicita notificar al emisor, así como borrar de su computadora y sistemas el 
presente mensaje y sus anexos, sin retener copia alguna de los mismos. El 
emisor no se responsabiliza por confiar indebidamente y sin autorización en el 
contenido de este correo. El contenido de este comunicado puede ser sujeto a 
reglas de exportación incluyendo las "Export Administration Regulations" de los 
Estados Unidos así como a las Reglas Administrativas de Exportación de México. 
Cualquier modificación contraria a la legislación aplicable está prohibida. 
Este mensaje no se considerará como ninguna oferta, aceptación o modificación 
de ningún contrato.
  ­­

RE: [mssms] Convert MOF to manager readable format

[Garth Jones]

Just remember it is easy to add more stuff to CMCB. So if they do an item by 
item compare then they should include that how easy is it to add more inventory 
items too.



From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Schultz, Michael A
Sent: Tuesday, December 13, 2016 7:56 PM
To: mssms@lists.myitforum.com
Subject: RE: [mssms] Convert MOF to manager readable format

We have SCCM and there is a CA tool (ITCM) in our enterprise that collects a 
lot of data.  We are hoping to just use SCCM but they want to see everything 
SCCM collects and could collect OOB from hardware inventory.  They are then 
going to compare the tool and decide.

Michael Schultz
Client Systems Engineering
Information Systems
Providence Health & Services
michael.schu...@providence.org

From: listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Sherry Kissinger
Sent: Tuesday, December 13, 2016 4:29 PM
To: mssms@lists.myitforum.com
Subject: Re: [mssms] Convert MOF to manager readable format

Personally, I'd reverse it.  "What do you, managers, want to see that you don't 
already see?"  Why? Even if you got it into a legible-ish format, you'd spend a 
lot of time trying to explain what each option actually *is*.

On Dec 13, 2016 4:12 PM, "Schultz, Michael A" 
> wrote:
Anyone have any recommendations for a tool or script that will read an exported 
HInv MOF and output something manager readable?  I have been tasked to report 
everything that is being inventoried and what is available to be inventoried.

Michael Schultz
Client Systems Engineering
Information Systems
Providence Health & Services
michael.schu...@providence.org




This message is intended for the sole use of the addressee, and may contain 
information that is privileged, confidential and exempt from disclosure under 
applicable law. If you are not the addressee you are hereby notified that you 
may not use, copy, disclose, or distribute to anyone the message or any 
information contained in the message. If you have received this message in 
error, please immediately advise the sender by reply email and delete this 
message.





This message is intended for the sole use of the addressee, and may contain 
information that is privileged, confidential and exempt from disclosure under 
applicable law. If you are not the addressee you are hereby notified that you 
may not use, copy, disclose, or distribute to anyone the message or any 
information contained in the message. If you have received this message in 
error, please immediately advise the sender by reply email and delete this 
message.

[mssms] RE: Blank Reports

[Garth Jones]

This report is based on Software Inventory (which is useless), instead use the 
report called Software registered in Add Remove Programs on a specific computer.

BTW, it is also recommend to access the reports via the web interface and not 
via the console too. There is a lot of overhead accessing the reports via the 
console.


From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Chace Alldredge
Sent: Wednesday, November 23, 2016 10:07 AM
To: mssms@lists.myITforum.com
Subject: [mssms] Blank Reports


Running into issues with reports not pulling inventory from machines, what logs 
or where should I look to resolve this?



[cid:image002.jpg@01D24BBB.C77E33B0]

[mssms] RE: Count physical disks

[Garth Jones]

Hi Stuart,

This will be a hard question to answer as if any of the systems have HW RAID 
then the OS will see that as one physical disk. The only way to see each disk 
within a HW Raid is for you to install  the WMI provider (if one exists) for 
the HW RAID controller then inventory the data listed within its WMI classes.

If you are just looking for the number of disks the OS sees then this query can 
help you.

Select
   RV.Netbios_name0,
   Count(D.ResourceID) as 'Disk Count'
from
   v_r_system_valid RV
   join v_gs_disk D on RV.ResourceID = D.ResourceID
Group by
   RV.Netbios_name0




From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Stuart Watret
Sent: Thursday, December 1, 2016 6:56 AM
To: mssms@lists.myitforum.com
Subject: [mssms] Count physical disks

Anyone share a bit of query magic I can utilise to count disks in machines, 
that’s all I need.

Cheers

Stuart Watret

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

[Garth Jones]

Thanks. I encourage everyone to submit reviews for my book or any other book 
that they have. It helps everyone. There is only person that I told not to 
review my book and it was my Mom. :-) She did post a note to Facebook about it. 
:-)


-Original Message-
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Erno, Cynthia M (ITS)
Sent: Monday, November 14, 2016 12:27 PM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: I think i like the old web reporting more then Reporting 
Services.. seems simpler

Very nice reviews Garth :-) 

Cynthia Erno

-Original Message-
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Garth Jones
Sent: Monday, November 14, 2016 11:36 AM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: I think i like the old web reporting more then Reporting 
Services.. seems simpler

ATTENTION: This email came from an external source. Do not open attachments or 
click on links from unknown senders or unexpected emails.


Here are the books for reporting, of course I love the first one. :-)

https://www.amazon.com/System-Configuration-Manager-Reporting-Unleashed/dp/0672337789/
https://www.amazon.com/System-Center-2012-Configuration-Manager/dp/9187445174/





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

Which books

Actually even more than that... I've been asked to provide a list of recommend 
training material and books for someone new to SCCM. I haven't read any of the 
new ones. What would you all recommend?








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

[External Email]

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.




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: I think i like the old web reporting more then Reporting Services.. seems simpler

[Garth Jones]

Here are the books for reporting, of course I love the first one. :-)

https://www.amazon.com/System-Configuration-Manager-Reporting-Unleashed/dp/0672337789/
https://www.amazon.com/System-Center-2012-Configuration-Manager/dp/9187445174/





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

Which books

Actually even more than that... I've been asked to provide a list of recommend 
training material and books for someone new to SCCM. I haven't read any of the 
new ones. What would you all recommend?








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

[External Email]

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.




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: 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. 

RE: RE: [EXTERNAL][mssms] Live Meeting Uninstall

[Garth Jones]

Use the query below.

*Copy the results into a text file

*Remove the most current version from the list. (Last line, hopefully)



Select
   'Msiexec /X '+ arp.prodid0 +' /q /norestart'
from
   v_add_remove_programs ARP
Where
   Displayname0 like '%live meeting%'
Order by
   ARP.Version0

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Brian McDonald
Sent: Tuesday, October 18, 2016 4:21 PM
To: mssms@lists.myitforum.com
Subject: Re: RE: [EXTERNAL][mssms] Live Meeting Uninstall


Eswar,



I have gathered all of the product codes, but not sure how to script this. Can 
you give me an example?



Thank you,



Brian


From: listsad...@lists.myitforum.com 
> on 
behalf of Eswar >
Sent: Monday, October 17, 2016 8:02:13 PM
To: mssms@lists.myitforum.com
Subject: Re: RE: [EXTERNAL][mssms] Live Meeting Uninstall


You can get the product ids of these different lync versions using sccm (simple 
query on v_add_remove_programs will do this) and then create batch/cmd to pipe 
all the product codes Into the script.
Script try to perform the uninstallstion on clients that has specific product 
code exist.

Msiexec /X productid /q /norestart

Adjust the parameters for msiexec accordingly.

--
Regards,
Eswar Koneti
www.eskonr.com
Sent from Mobile Device, please excuse any typo's as a result.
Tuesday, 18 October 2016, 04:53AM +08:00 from Matthew Varnado 
matthew.varn...@exeterfinance.com:



Simple shell script solution (untested with this product, but works for other 
products regularly)



wmic product where 'name like "%%Live Meeting%%"' call uninstall /nointeractive



note the single quotes around the logic phrase, and the double quotes around 
the search string.  Double % are used for the wildcards because if you do 
single % it tries to find a variable by that name.



This also assumes only a single version would be installed at a time.  Run 
multiple times for multiple installs (if possible), or work out a FOR loop to 
execute the command for each match found.



Another option (requiring a lot more research) is to find all the PIDS and do a 
series of msiexec /x[PID] /qn commands.









Matt Varnado |



From: 
listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald
Sent: Monday, October 17, 2016 2:27 PM
To: mssms@lists.myitforum.com
Subject: [EXTERNAL][mssms] Live Meeting Uninstall



Hello,



Does anyone have a method or process for uninstalling ALL versions of Microsoft 
Live Meeting. In my environment we have approximately 9 different versions of 
Live Meeting. Since the installers are all MSI based, I was hoping there would 
be an easy way to script/automate the uninstall so I would only require 1 
single package to get the job done in SCCM.



When I say multiple versions, here is what I mean:



8.0.6362.187

8.0.6362.202

8.0.6362.215

8.0.6362.223

8.0.6362.229

8.0.6362.239

8.0.6362.249

8.0.6362.254

8.0.6362.259



What would be the best way to package an uninstall script to tackle this? I 
don't want to have multiple MSI uninstall packages. Can someone provide some 
insight on to a recommended approach?



Thanks,

Brian




Confidentiality Warning: This transmission is intended only for the proper 
recipient and may contain information that is confidential and/or privileged. 
If you received this message in error or are not the intended recipient, (A) 
you are hereby notified that the dissemination, distribution or copying of this 
message is strictly prohibited, (B) please notify the sender at either the 
e-mail address or telephone number above, and (C) delete this email from your 
computer. Thank you.

[mssms] RE: Microsoft, please standardize on a single image management tool

[Garth Jones]

Done and Tweeted!

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Daniel Ratliff
Sent: Monday, October 17, 2016 12:54 PM
To: mssms@lists.myitforum.com
Subject: [mssms] Microsoft, please standardize on a single image management tool

https://www.change.org/p/microsoft-microsoft-please-standardize-on-a-single-image-management-solution?recruiter=10885997_source=share_for_starters_medium=copyLink

We feel a lot of pain from this, and Johan agrees this is a good idea. If you 
do to, please consider signing.

Daniel Ratliff


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.

Re: [mssms] SCCM 2016 - Does SCCM 2016 Released ?

[Garth Jones]

It is called cm1606.

Sent from my iPhone

On Oct 9, 2016, at 10:26 AM, S ConfigMgr 
> wrote:

Does SCCM 2016 Released ?

or it will called as CM 1606 ?

--
Thanks,
ED

Re: [mssms] Horrible food at Ignite

[Garth Jones]

Lol I was 5am when I posted that, with no coffee...

Sent from my iPhone

On Sep 29, 2016, at 11:34 AM, Erno, Cynthia M (ITS) 
<cynthia.e...@its.ny.gov<mailto:cynthia.e...@its.ny.gov>> wrote:

If you can “sever” it out of his hands :) :) :)
Sorry Garth, but you did you use the word severed instead of served.. 3x.

Cynthia Erno

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Heaton, Joseph@Wildlife
Sent: Thursday, September 29, 2016 10:31 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: RE: [mssms] Horrible food at Ignite


ATTENTION: This email came from an external source. Do not open attachments or 
click on links from unknown senders or unexpected emails.

Mmm, peach cobbler.  I’d be happy to take yours off your hands, Garth, since 
you’re watching your weight. ;)

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones
Sent: Thursday, September 29, 2016 3:39 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: RE: [mssms] Horrible food at Ignite

I’m just providing the details that I was told as to why we have lunch boxes vs 
hot food. Like you I prefer hot food but it does mean that you have to wait in 
line to be severed.

This question was not who wanted lunch boxes, the issue was how long it took to 
be severed. Even thought I go to the vendor food hall, it always seen to take 5 
minutes before you could make it to the food table before getting severed. Then 
it would take a bit longer to slowly make you way to the other end. If anything 
ran out you would wait until they replaced it. This year there has been no 
waiting to grab a lunch box.

Again my understanding is that the cost is exactly the same for MS for the 
lunch boxes, and the quality is much higher than your normal lunch boxed. I 
would agree that these lunch boxes are a lot high quality than normal lunch 
boxes. When do you see cut fresh fruit in a lunch box and a peach cobbler?

Don’t get me wrong, I want a hot lunch. All I’m doing is giving another 
prospective on things.

Food waste will happen with both lunch boxes and catered food, I agree that it 
will be less with catered. But on the plus side, I’m trying to watch my weight, 
so a box lunch, will help keep me in check. :)

BTW, I was also told that the boxes are recycled however because they are a 
hard plastic, I wouldn’t be surprised if they are washed and reused.

BBTW, I was talking @RicksterCDN about this on Sunday night this is the only 
reason why I know any of this. He is a good guy and if you can catch him or 
Joey, I’m sure that they will give you more details about this.


From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Roland Janus
Sent: September 28, 2016 1:49 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: AW: [mssms] Horrible food at Ignite

How many actually asked for the lunch boxes instead of warm and proper cooked 
food?
The majority prefers  that over a cooked meal?
I have a hard time believing that and I never waited that long.
But it certainly is cheaper for MS, but I do think we pay enough to get 
something better regardless
Maybe I’m just spoiled with real bread (coming from Europe) and not that piece 
of tasteless foam used.
And then that dry chicken. B.

Not even talking about how many half used boxes go into the garbage.


Von: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] Im Auftrag von Garth Jones
Gesendet: Mittwoch, 28. September 2016 17:20
An: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Betreff: RE: [mssms] Horrible food at Ignite

So I talked to the team about this and the Lunch boxes was the feed back that 
they got form last ignite. People didn’t want to wait for 20-30 minutes to get 
food. They wanted to get in and out in 5 minutes so that they can talk to 
friends, office, family during the breaks.

So what they did was if they spent $30 on hot food per person, they turned 
around bought lunch that cost $30/each, this way you get better food and can 
get in and out within a few minutes. Therefore you don’t have to wait in line 
for you food nearly as long…


Right, wrong… I’m just says that is why we have lunch boxes..



From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Roland Janus
Sent: September 27, 2016 12:21 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] Horrible food at Ignite

I’m kind of surprised that there are not a zillion comments about the horrible 
food we get at Ignite.

Cold sandwiches? Seriously and like the same every day?
I’ve good

Re: [mssms] Horrible food at Ignite

[Garth Jones]

Lol... I will keep it for you. ?

Sent from my iPhone

On Sep 29, 2016, at 10:43 AM, Heaton, Joseph@Wildlife 
<joseph.hea...@wildlife.ca.gov<mailto:joseph.hea...@wildlife.ca.gov>> wrote:

Mmm, peach cobbler.  I'd be happy to take yours off your hands, Garth, since 
you're watching your weight. ;)

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones
Sent: Thursday, September 29, 2016 3:39 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: RE: [mssms] Horrible food at Ignite

I'm just providing the details that I was told as to why we have lunch boxes vs 
hot food. Like you I prefer hot food but it does mean that you have to wait in 
line to be severed.

This question was not who wanted lunch boxes, the issue was how long it took to 
be severed. Even thought I go to the vendor food hall, it always seen to take 5 
minutes before you could make it to the food table before getting severed. Then 
it would take a bit longer to slowly make you way to the other end. If anything 
ran out you would wait until they replaced it. This year there has been no 
waiting to grab a lunch box.

Again my understanding is that the cost is exactly the same for MS for the 
lunch boxes, and the quality is much higher than your normal lunch boxed. I 
would agree that these lunch boxes are a lot high quality than normal lunch 
boxes. When do you see cut fresh fruit in a lunch box and a peach cobbler?

Don't get me wrong, I want a hot lunch. All I'm doing is giving another 
prospective on things.

Food waste will happen with both lunch boxes and catered food, I agree that it 
will be less with catered. But on the plus side, I'm trying to watch my weight, 
so a box lunch, will help keep me in check. :)

BTW, I was also told that the boxes are recycled however because they are a 
hard plastic, I wouldn't be surprised if they are washed and reused.

BBTW, I was talking @RicksterCDN about this on Sunday night this is the only 
reason why I know any of this. He is a good guy and if you can catch him or 
Joey, I'm sure that they will give you more details about this.


From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Roland Janus
Sent: September 28, 2016 1:49 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: AW: [mssms] Horrible food at Ignite

How many actually asked for the lunch boxes instead of warm and proper cooked 
food?
The majority prefers  that over a cooked meal?
I have a hard time believing that and I never waited that long.
But it certainly is cheaper for MS, but I do think we pay enough to get 
something better regardless
Maybe I'm just spoiled with real bread (coming from Europe) and not that piece 
of tasteless foam used.
And then that dry chicken. B.

Not even talking about how many half used boxes go into the garbage.


Von: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] Im Auftrag von Garth Jones
Gesendet: Mittwoch, 28. September 2016 17:20
An: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Betreff: RE: [mssms] Horrible food at Ignite

So I talked to the team about this and the Lunch boxes was the feed back that 
they got form last ignite. People didn't want to wait for 20-30 minutes to get 
food. They wanted to get in and out in 5 minutes so that they can talk to 
friends, office, family during the breaks.

So what they did was if they spent $30 on hot food per person, they turned 
around bought lunch that cost $30/each, this way you get better food and can 
get in and out within a few minutes. Therefore you don't have to wait in line 
for you food nearly as long...


Right, wrong... I'm just says that is why we have lunch boxes..



From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Roland Janus
Sent: September 27, 2016 12:21 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] Horrible food at Ignite

I'm kind of surprised that there are not a zillion comments about the horrible 
food we get at Ignite.

Cold sandwiches? Seriously and like the same every day?
I've good better food on any airplane and it's warm.

That is just not acceptable.

-R

RE: [mssms] Horrible food at Ignite

[Garth Jones]

I'm just providing the details that I was told as to why we have lunch boxes vs 
hot food. Like you I prefer hot food but it does mean that you have to wait in 
line to be severed.

This question was not who wanted lunch boxes, the issue was how long it took to 
be severed. Even thought I go to the vendor food hall, it always seen to take 5 
minutes before you could make it to the food table before getting severed. Then 
it would take a bit longer to slowly make you way to the other end. If anything 
ran out you would wait until they replaced it. This year there has been no 
waiting to grab a lunch box.

Again my understanding is that the cost is exactly the same for MS for the 
lunch boxes, and the quality is much higher than your normal lunch boxed. I 
would agree that these lunch boxes are a lot high quality than normal lunch 
boxes. When do you see cut fresh fruit in a lunch box and a peach cobbler?

Don't get me wrong, I want a hot lunch. All I'm doing is giving another 
prospective on things.

Food waste will happen with both lunch boxes and catered food, I agree that it 
will be less with catered. But on the plus side, I'm trying to watch my weight, 
so a box lunch, will help keep me in check. :)

BTW, I was also told that the boxes are recycled however because they are a 
hard plastic, I wouldn't be surprised if they are washed and reused.

BBTW, I was talking @RicksterCDN about this on Sunday night this is the only 
reason why I know any of this. He is a good guy and if you can catch him or 
Joey, I'm sure that they will give you more details about this.


From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Roland Janus
Sent: September 28, 2016 1:49 PM
To: mssms@lists.myitforum.com
Subject: AW: [mssms] Horrible food at Ignite

How many actually asked for the lunch boxes instead of warm and proper cooked 
food?
The majority prefers  that over a cooked meal?
I have a hard time believing that and I never waited that long.
But it certainly is cheaper for MS, but I do think we pay enough to get 
something better regardless
Maybe I'm just spoiled with real bread (coming from Europe) and not that piece 
of tasteless foam used.
And then that dry chicken. B.

Not even talking about how many half used boxes go into the garbage.


Von: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] Im Auftrag von Garth Jones
Gesendet: Mittwoch, 28. September 2016 17:20
An: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Betreff: RE: [mssms] Horrible food at Ignite

So I talked to the team about this and the Lunch boxes was the feed back that 
they got form last ignite. People didn't want to wait for 20-30 minutes to get 
food. They wanted to get in and out in 5 minutes so that they can talk to 
friends, office, family during the breaks.

So what they did was if they spent $30 on hot food per person, they turned 
around bought lunch that cost $30/each, this way you get better food and can 
get in and out within a few minutes. Therefore you don't have to wait in line 
for you food nearly as long...


Right, wrong... I'm just says that is why we have lunch boxes..



From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Roland Janus
Sent: September 27, 2016 12:21 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] Horrible food at Ignite

I'm kind of surprised that there are not a zillion comments about the horrible 
food we get at Ignite.

Cold sandwiches? Seriously and like the same every day?
I've good better food on any airplane and it's warm.

That is just not acceptable.

-R

RE: [mssms] Horrible food at Ignite

[Garth Jones]

So I talked to the team about this and the Lunch boxes was the feed back that 
they got form last ignite. People didn't want to wait for 20-30 minutes to get 
food. They wanted to get in and out in 5 minutes so that they can talk to 
friends, office, family during the breaks.

So what they did was if they spent $30 on hot food per person, they turned 
around bought lunch that cost $30/each, this way you get better food and can 
get in and out within a few minutes. Therefore you don't have to wait in line 
for you food nearly as long...


Right, wrong... I'm just says that is why we have lunch boxes..



From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Roland Janus
Sent: September 27, 2016 12:21 PM
To: mssms@lists.myitforum.com
Subject: [mssms] Horrible food at Ignite

I'm kind of surprised that there are not a zillion comments about the horrible 
food we get at Ignite.

Cold sandwiches? Seriously and like the same every day?
I've good better food on any airplane and it's warm.

That is just not acceptable.

-R

RE: [mssms] SCCM 2007 Deny permissions on 1 report.

[Garth Jones]

If I remember right in CM07 ONLY, you can do this within SSRS itself. BUT keep 
in mind that the permission might get reset if the RP point is ever 
re-installed.

In CM12 and later, there is no easy way to do this.



Garth Jones
Chief Architect

www.Enhansoft.com<http://www.enhansoft.com/>
[Description: Description: 
cid:image001.jpg@01CC63FB.974F4EC0]<http://www.enhansoft.com/>
Enhancing Your Business
[Description: Description: Description: Description: Description: Description: 
Description: 
cid:image004.png@01CD5E19.F3C3A110]<http://www.enhansoft.com/blog>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image005.png@01CD5E19.F3C3A110]<https://twitter.com/enhansoft>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image006.jpg@01CD5E19.F3C3A110]<http://www.facebook.com/EnhansoftInc>[Description:
 Description: Description: Description: Description: Description: Description: 
Description: Description: Description: Description: Description: Description: 
Description: Description: Enhansoft's YouTube 
Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description: 
Description: Description: Description: Description: Description: 
cid:image007.png@01CD5E19.F3C3A110]<http://myitforum.com/myitforumwp/community/groups/enhansoft/>

Subscribe to Enhansoft's Newsletter!<http://www.enhansoft.com/register>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Stefanie Burton
Sent: Monday, September 26, 2016 12:09 PM
To: mssms@lists.myitforum.com
Subject: [mssms] SCCM 2007 Deny permissions on 1 report.

Does anyone still work with 2007?

I need to deny permissions on 1 report to a group who has read rights on the 
reports class.   If I take away class rights then the users cannot see all the 
reports they need to be able to view.

Is the only way to do this is to give them read instance rights to all reports 
except the one I don't want to give them access too?

Any help is appreciated.

Thanks

RE: [mssms] Microsoft Ignite

[Garth Jones]

Here is the list of Sessions that I flagged as interesting.. Times are not in 
order.


Garth Jones
Chief Architect

www.Enhansoft.com<http://www.enhansoft.com/>
[Description: Description: 
cid:image001.jpg@01CC63FB.974F4EC0]<http://www.enhansoft.com/>
Enhancing Your Business
[Description: Description: Description: Description: Description: Description: 
Description: 
cid:image004.png@01CD5E19.F3C3A110]<http://www.enhansoft.com/blog>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image005.png@01CD5E19.F3C3A110]<https://twitter.com/enhansoft>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image006.jpg@01CD5E19.F3C3A110]<http://www.facebook.com/EnhansoftInc>[Description:
 Description: Description: Description: Description: Description: Description: 
Description: Description: Description: Description: Description: Description: 
Description: Description: Enhansoft's YouTube 
Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description: 
Description: Description: Description: Description: Description: 
cid:image007.png@01CD5E19.F3C3A110]<http://myitforum.com/myitforumwp/community/groups/enhansoft/>

Subscribe to Enhansoft’s Newsletter!<http://www.enhansoft.com/register>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Garth Jones
Sent: Saturday, September 24, 2016 9:13 AM
To: mssms@lists.myitforum.com
Subject: Re: [mssms] Microsoft Ignite

I'm already here... Heading to the Waffle House for breakfast then to the 
Weston to register! 

There r a number of theatre sessions  that have cm or other interesting 
content. I will dig up the list that I made and send it a long after breakfast.

Sent from my iPhone

On Sep 23, 2016, at 3:13 PM, Brian Illner 
<brian.ill...@canal-ins.com<mailto:brian.ill...@canal-ins.com>> wrote:
Who’s headed to Ignite next week and what are the ConfigMgr sessions not to 
miss?

BRIAN ILLNER | Senior Systems Administrator
864.250.9227
864.679.2537 Fax

Canal Insurance Company
400 East Stone Avenue
Greenville, SC 29601
Visit canalinsurance.com<http://canalinsurance.com> for news and information.

<https://www.linkedin.com/company/canal-insurance-company>
WARNING:  As the information in this transmittal (including attachments, if 
any) may contain confidential, proprietary, or business trade secret 
information, it should only be reviewed by those who are the intended 
recipients.  Unless you are an intended recipient, any review, use, disclosure, 
distribution or copying of this transmittal (or any attachments) is strictly 
prohibited.   If you have received this transmittal in error, please notify me 
immediately by reply email and destroy all copies of the transmittal.  While 
Canal believes this transmittal to be free of virus or other defect, it is the 
responsibility of the recipient to ensure that it is virus free and no 
responsibility is accepted by Canal (or its subsidiaries and affiliates) for 
any loss or damage arising therefrom.





MS Ignite 2016 Best Sessions.xlsx
Description: MS Ignite 2016 Best Sessions.xlsx

Re: [mssms] Microsoft Ignite

[Garth Jones]

I'm already here... Heading to the Waffle House for breakfast then to the 
Weston to register! ?

There r a number of theatre sessions  that have cm or other interesting 
content. I will dig up the list that I made and send it a long after breakfast.

Sent from my iPhone

On Sep 23, 2016, at 3:13 PM, Brian Illner 
> wrote:

Who's headed to Ignite next week and what are the ConfigMgr sessions not to 
miss?

BRIAN ILLNER | Senior Systems Administrator
864.250.9227
864.679.2537 Fax

Canal Insurance Company
400 East Stone Avenue
Greenville, SC 29601
Visit canalinsurance.com for news and information.


WARNING:  As the information in this transmittal (including attachments, if 
any) may contain confidential, proprietary, or business trade secret 
information, it should only be reviewed by those who are the intended 
recipients.  Unless you are an intended recipient, any review, use, disclosure, 
distribution or copying of this transmittal (or any attachments) is strictly 
prohibited.   If you have received this transmittal in error, please notify me 
immediately by reply email and destroy all copies of the transmittal.  While 
Canal believes this transmittal to be free of virus or other defect, it is the 
responsibility of the recipient to ensure that it is virus free and no 
responsibility is accepted by Canal (or its subsidiaries and affiliates) for 
any loss or damage arising therefrom.

RE: [mssms] Find computers without specific software installed

[Garth Jones]

Use ARP. It is has the most reliable data... Use a sub select query.

Here is the blog post on how to do this too.  
http://www.enhansoft.com/blog/subselect-wql-query-to-find-pcs-that-do-not-have-either-x86-or-x64-versions-of-software-installed






Garth Jones
Chief Architect

www.Enhansoft.com<http://www.enhansoft.com/>
[Description: Description: 
cid:image001.jpg@01CC63FB.974F4EC0]<http://www.enhansoft.com/>
Enhancing Your Business
[Description: Description: Description: Description: Description: Description: 
Description: 
cid:image004.png@01CD5E19.F3C3A110]<http://www.enhansoft.com/blog>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image005.png@01CD5E19.F3C3A110]<https://twitter.com/enhansoft>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image006.jpg@01CD5E19.F3C3A110]<http://www.facebook.com/EnhansoftInc>[Description:
 Description: Description: Description: Description: Description: Description: 
Description: Description: Description: Description: Description: Description: 
Description: Description: Enhansoft's YouTube 
Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description: 
Description: Description: Description: Description: Description: 
cid:image007.png@01CD5E19.F3C3A110]<http://myitforum.com/myitforumwp/community/groups/enhansoft/>

Subscribe to Enhansoft's Newsletter!<http://www.enhansoft.com/register>


From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Haritwal, Dhiraj
Sent: Wednesday, September 14, 2016 11:04 AM
To: mssms@lists.myITforum.com<mailto:mssms@lists.myITforum.com>
Subject: [mssms] Find computers without specific software installed

Hi,

I am trying to create a collection (WQL) with computers which doesn't have 
specific software installed like any Antivirus & used SMS_R_System with 
SMS_G_System_ADD_REMOVE_PROGRAMS & getting desired results. While checking the 
same for another software, getting half data in 
SMS_G_System_ADD_REMOVE_PROGRAMS & half data in 
SMS_G_System_ADD_REMOVE_PROGRAMS_64 which is confusing

Is it the correct behaviour? Which WQL table we should use to get software 
installation details? Does it mean, 32bit softwares will get stored in 
ADD_Remove_Programs & 64bit software in SMS_G_System_ADD_REMOVE_PROGRAMS_64 
table?

How can we check what are the table/fields (column) available in WQL. Was 
trying with wbemtest


Appreciate any help.


Regards,

Dhiraj





This email is confidential and intended only for the use of the individual or 
entity named above and may contain information that is privileged. If you are 
not the intended recipient, you are notified that any dissemination, 
distribution or copying of this email is strictly prohibited. If you have 
received this email in error, please notify us immediately by return email or 
telephone and destroy the original message. - This mail is sent via Sony Asia 
Pacific Mail Gateway..


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.

RE: [mssms] RE: Help with a few SQL queries

[Garth Jones]

So what are the SQL view names that it created?  V_GS_ TEST_Outlook and V_GS_ 
TEST_Outlook64?



Garth Jones
Chief Architect

www.Enhansoft.com<http://www.enhansoft.com/>
[Description: Description: 
cid:image001.jpg@01CC63FB.974F4EC0]<http://www.enhansoft.com/>
Enhancing Your Business
[Description: Description: Description: Description: Description: Description: 
Description: 
cid:image004.png@01CD5E19.F3C3A110]<http://www.enhansoft.com/blog>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image005.png@01CD5E19.F3C3A110]<https://twitter.com/enhansoft>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image006.jpg@01CD5E19.F3C3A110]<http://www.facebook.com/EnhansoftInc>[Description:
 Description: Description: Description: Description: Description: Description: 
Description: Description: Description: Description: Description: Description: 
Description: Description: Enhansoft's YouTube 
Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description: 
Description: Description: Description: Description: Description: 
cid:image007.png@01CD5E19.F3C3A110]<http://myitforum.com/myitforumwp/community/groups/enhansoft/>

Subscribe to Enhansoft's Newsletter!<http://www.enhansoft.com/register>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Brian McDonald
Sent: Monday, September 12, 2016 12:53 PM
To: mssms@lists.myitforum.com
Subject: Re: [mssms] RE: Help with a few SQL queries


Yes, here is the MOF edit.


pragma namespace (".\\root\\cimv2\\SMS")
#pragma deleteclass("TEST_Outlook", NOFAIL)
[SMS_Report(FALSE),SMS_Group_Name("TEST_Outlook"),SMS_Class_ID("TEST_BM|TEST_Outlook|1.0"),
SMS_Context_1("__ProviderArchitecture=32|uint32"),
SMS_Context_2("__RequiredArchitecture=true|boolean")]
Class TEST_Outlook: SMS_Class_Template
{
[SMS_Report(FALSE),key] string KeyName;
[SMS_Report(TRUE)] String Bitness;
[SMS_Report(TRUE)] String InternetMail;
[SMS_Report(TRUE)] String MicrosoftExchangeServer;
};

#pragma namespace (".\\root\\cimv2\\SMS")
#pragma deleteclass("TEST_Outlook_64", NOFAIL)
[SMS_Report(FALSE),SMS_Group_Name("TEST_Outlook64"),SMS_Class_ID("TEST_BM|TEST_Outlook64|1.0"),
SMS_Context_1("__ProviderArchitecture=64|uint32"),
SMS_Context_2("__RequiredArchitecture=true|boolean")]
Class TEST_Outlook_64 : SMS_Class_Template
{
[SMS_Report(FALSE),key] string KeyName;
[SMS_Report(TRUE)] String Bitness;
[SMS_Report(TRUE)] String InternetMail;
[SMS_Report(TRUE)] String MicrosoftExchangeServer;
};


From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
<listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>> on 
behalf of Garth Jones <ga...@enhansoft.com<mailto:ga...@enhansoft.com>>
Sent: Monday, September 12, 2016 9:19:33 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: RE: [mssms] RE: Help with a few SQL queries

So did you create the MOF edit yet? Has the inventory been collected?



Garth Jones
Chief Architect

www.Enhansoft.com<http://www.enhansoft.com/>
[Description: Description: 
cid:image001.jpg@01CC63FB.974F4EC0]<http://www.enhansoft.com/>
Enhancing Your Business
[Description: Description: Description: Description: Description: Description: 
Description: 
cid:image004.png@01CD5E19.F3C3A110]<http://www.enhansoft.com/blog>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image005.png@01CD5E19.F3C3A110]<https://twitter.com/enhansoft>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image006.jpg@01CD5E19.F3C3A110]<http://www.facebook.com/EnhansoftInc>[Description:
 Description: Description: Description: Description: Description: Description: 
Description: Description: Description: Description: Description: Description: 
Description: Description: Enhansoft's YouTube 
Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description: 
Description: Description: Description: Description: Description: 
cid:image007.png@01CD5E19.F3C3A110]<http://myitforum.com/myitforumwp/community/groups/enhansoft/>

Subscribe to Enhansoft's Newsletter!<http://www.enhansoft.com/register>

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald
Sent: Sunday, September 11, 2016 10:57 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: Re: [mssms] RE: Help with a few SQL queries

Garth,

I used RegKeyToMof to inventory the key found in the following link:
https://www.ronnipedersen.com/2012/11/application-requirement-f

RE: [mssms] RE: Help with a few SQL queries

[Garth Jones]

I like the idea, it is clever but there is problem with this query. All x86 
computers will show up as having the x64 version as they don't have (x86) 
within the path name. This also assumes that all installs are within the 
Program files directory, I agree that is generally a safe bet but not 100%.



Garth Jones
Chief Architect

www.Enhansoft.com<http://www.enhansoft.com/>
[Description: Description: 
cid:image001.jpg@01CC63FB.974F4EC0]<http://www.enhansoft.com/>
Enhancing Your Business
[Description: Description: Description: Description: Description: Description: 
Description: 
cid:image004.png@01CD5E19.F3C3A110]<http://www.enhansoft.com/blog>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image005.png@01CD5E19.F3C3A110]<https://twitter.com/enhansoft>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image006.jpg@01CD5E19.F3C3A110]<http://www.facebook.com/EnhansoftInc>[Description:
 Description: Description: Description: Description: Description: Description: 
Description: Description: Description: Description: Description: Description: 
Description: Description: Enhansoft's YouTube 
Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description: 
Description: Description: Description: Description: Description: 
cid:image007.png@01CD5E19.F3C3A110]<http://myitforum.com/myitforumwp/community/groups/enhansoft/>

Subscribe to Enhansoft's Newsletter!<http://www.enhansoft.com/register>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Hatem Mohamed
Sent: Friday, September 9, 2016 5:03 PM
To: mssms@lists.myitforum.com
Subject: RE: [mssms] RE: Help with a few SQL queries

This should work for you. The Netbios name from v_R_System_Valid is joined 
below to allow you to match the computer names to the architecture version of 
office you're looking for.

Select
v_R_System_Valid.Netbios_Name0,
v_GS_INSTALLED_SOFTWARE.ARPDisplayName0,
v_GS_INSTALLED_SOFTWARE.InstalledLocation0,
CASE When v_GS_INSTALLED_SOFTWARE.InstalledLocation0 Like '%(x86)%' Then 
'x86' Else 'x64' End AS [DetectedArchitecture]

>From v_GS_INSTALLED_SOFTWARE
INNER JOIN v_R_System_Valid ON v_GS_INSTALLED_SOFTWARE.ResourceID = 
v_R_System_Valid.ResourceID

Where ARPDisplayName0 = 'Microsoft Office Professional Plus 2013'

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald
Sent: Friday, September 9, 2016 1:07 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: Re: [mssms] RE: Help with a few SQL queries


Todd - this is great! The one thing I need to know is which workstations have 
this. How do I add that to the query?



Thanks,

Brian


From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
<listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>> on 
behalf of Todd Hemsell <hems...@gmail.com<mailto:hems...@gmail.com>>
Sent: Friday, September 2, 2016 4:17:47 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: Re: [mssms] RE: Help with a few SQL queries

Select

ARPDisplayName0,
InstalledLocation0,
CASE When InstalledLocation0 Like '%(x86)%' Then 'x86' Else 'x64' End AS 
[DetectedArchitecture]

>From v_GS_INSTALLED_SOFTWARE

Where ARPDisplayName0 = 'Microsoft Office Professional Plus 2013'

On Fri, Sep 2, 2016 at 2:16 PM, Brian McDonald 
<mcdonald...@hotmail.com<mailto:mcdonald...@hotmail.com>> wrote:

Sorry, a bit of a newbie with this. How exactly to I pull the data? Can someone 
provide a sample query?



Thank you,

Brian


From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
<listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>> on 
behalf of Marcum, John <jmar...@bradley.com<mailto:jmar...@bradley.com>>
Sent: Wednesday, August 31, 2016 6:50:46 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: RE: [mssms] RE: Help with a few SQL queries

Once that key is inventoried you will have a custom view with the data you need.

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>] 
On Behalf Of Brian McDonald
Sent: Tuesday, August 30, 2016 2:33 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: Re: [mssms] RE: Help with a few SQL queries


This is great. Thanks John.



I'll extend the MOF key. Once I've done that, what is the best way to pull 
inventory on those clients with that particular REG key?



Thank you!



Brian


From: listsad...@lists.myitf

[mssms] RE: Configuration Manager Local SQL Best Practice Documentation

[Garth Jones]

Let put it this way, for 400,000 computer Microsoft will NOT say if SQL should 
be local or remote. Which BTW, SQL is hosted locally on a site with 400,000 
computers too. The Admins of that site are on this list too. ☺

Like John said no MVP will say that you should put SQL remote, Heck if I’m 
doing the install and SQL is remote, I add 15 days to the project due to all 
the headache that arise from remote SQL.






Garth Jones
Chief Architect

www.Enhansoft.com<http://www.enhansoft.com/>
[Description: Description: 
cid:image001.jpg@01CC63FB.974F4EC0]<http://www.enhansoft.com/>
Enhancing Your Business
[Description: Description: Description: Description: Description: Description: 
Description: 
cid:image004.png@01CD5E19.F3C3A110]<http://www.enhansoft.com/blog>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image005.png@01CD5E19.F3C3A110]<https://twitter.com/enhansoft>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image006.jpg@01CD5E19.F3C3A110]<http://www.facebook.com/EnhansoftInc>[Description:
 Description: Description: Description: Description: Description: Description: 
Description: Description: Description: Description: Description: Description: 
Description: Description: Enhansoft's YouTube 
Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description: 
Description: Description: Description: Description: Description: 
cid:image007.png@01CD5E19.F3C3A110]<http://myitforum.com/myitforumwp/community/groups/enhansoft/>

Subscribe to Enhansoft’s Newsletter!<http://www.enhansoft.com/register>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Johns, Damon (DoJ)
Sent: Wednesday, September 7, 2016 11:27 PM
To: mssms@lists.myitforum.com
Subject: [mssms] Configuration Manager Local SQL Best Practice Documentation

Hi Everyone,

Can anyone point me to the Microsoft TechNet documentation where they recommend 
that SQL be installed locally where a Primary Site has 50,000 clients or less? 
I’ve found a couple of blogs where people mentioned this but nothing specific 
from Microsoft.

I’ve also found a number of blogs where MVP’s strongly recommend this, but 
again nothing from Microsoft directly or the Configuration Manager team.

There must be something out there!?

Cheers
Damon



CONFIDENTIALITY NOTICE AND DISCLAIMER
The information in this transmission may be confidential and/or protected by 
legal professional privilege, and is intended only for the person or persons to 
whom it is addressed. If you are not such a person, you are warned that any 
disclosure, copying or dissemination of the information is unauthorised. If you 
have received the transmission in error, please immediately contact this office 
by telephone, fax or email, to inform us of the error and to enable 
arrangements to be made for the destruction of the transmission, or its return 
at our cost. No liability is accepted for any unauthorised use of the 
information contained in this transmission.

RE: [mssms] RE: SQL Query Help with total and count

[Garth Jones]

ay.. but having looked at this again.. You can do it easy enough.. it is listed 
on my old blog site. http://sccmug.ca/2014/03/19/count-of-pcs-by-ou-v2/






Garth Jones
Chief Architect

www.Enhansoft.com<http://www.enhansoft.com/>
[Description: Description: 
cid:image001.jpg@01CC63FB.974F4EC0]<http://www.enhansoft.com/>
Enhancing Your Business
[Description: Description: Description: Description: Description: Description: 
Description: 
cid:image004.png@01CD5E19.F3C3A110]<http://www.enhansoft.com/blog>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image005.png@01CD5E19.F3C3A110]<https://twitter.com/enhansoft>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image006.jpg@01CD5E19.F3C3A110]<http://www.facebook.com/EnhansoftInc>[Description:
 Description: Description: Description: Description: Description: Description: 
Description: Description: Description: Description: Description: Description: 
Description: Description: Enhansoft's YouTube 
Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description: 
Description: Description: Description: Description: Description: 
cid:image007.png@01CD5E19.F3C3A110]<http://myitforum.com/myitforumwp/community/groups/enhansoft/>

Subscribe to Enhansoft’s Newsletter!<http://www.enhansoft.com/register>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Todd Hemsell
Sent: Thursday, September 1, 2016 3:47 PM
To: mssms@lists.myitforum.com
Subject: Re: [mssms] RE: SQL Query Help with total and count

missing the counts per ou. :)


On Thu, Sep 1, 2016 at 10:31 AM, Garth Jones 
<ga...@enhansoft.com<mailto:ga...@enhansoft.com>> wrote:
Try this.,

select
   DS.Name0 as'Computer Name',
   DS.Creation_Date0 as 'Date',
   DS.Operating_System_Name_and0 as 'Operating System',
   OS.Caption0,
   max(OU.System_OU_Name0) as 'OU Name'
FROM
   dbo.v_R_System DS
   Inner Join dbo.v_RA_System_SystemOUName OU on OU.ResourceID = 
DS.ResourceID
   left outer join v_GS_OPERATING_SYSTEM OS on OS.ResourceID = DS.ResourceID
*WHERE
   DS.Operating_System_Name_and0 like '%10%'
   and DateDiff(dd,DS.Creation_Date0, GetDate ()) <= 1
Group BY
   DS.Name0,
   DS.Creation_Date0,
   DS.Operating_System_Name_and0,
   OS.Caption0,
   OU.System_OU_Name0
Order BY
   DS.Name0,
   DS.Creation_Date0,
   DS.Operating_System_Name_and0,
   OS.Caption0,
   OU.System_OU_Name0




Garth Jones
Chief Architect

www.Enhansoft.com<http://www.enhansoft.com/>
[Description: Description: 
cid:image001.jpg@01CC63FB.974F4EC0]<http://www.enhansoft.com/>
Enhancing Your Business
[Description: Description: Description: Description: Description: Description: 
Description: 
cid:image004.png@01CD5E19.F3C3A110]<http://www.enhansoft.com/blog>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image005.png@01CD5E19.F3C3A110]<https://twitter.com/enhansoft>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image006.jpg@01CD5E19.F3C3A110]<http://www.facebook.com/EnhansoftInc>[Description:
 Description: Description: Description: Description: Description: Description: 
Description: Description: Description: Description: Description: Description: 
Description: Description: Enhansoft's YouTube 
Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description: 
Description: Description: Description: Description: Description: 
cid:image007.png@01CD5E19.F3C3A110]<http://myitforum.com/myitforumwp/community/groups/enhansoft/>

Subscribe to Enhansoft’s Newsletter!<http://www.enhansoft.com/register>

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>] 
On Behalf Of Boseman, Marcia H - Raleigh, NC
Sent: Wednesday, August 31, 2016 11:04 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] SQL Query Help with total and count

I am running the query below and want to remove duplicates and then get a count 
of machines by OU.  Any help would be appreciated
select DS.Name0 [Computer Name],
DS.Creation_Date0 [Date], DS.Operating_System_Name_and0 [Operating System], 
OU.System_OU_Name0 [OU Name]
FROM
dbo.System_DISC DS
Inner Join dbo.System_System_OU_Name_ARR OU on OU.ItemKey = DS.ItemKey
WHERE Operating_System_Name_and0 like '%10%' and
DateDiff(dd,Creation_Date0, GetDate ()) <= 1
Group BY Name0, Creation_Date0, Operating_System_Name_and0, System_OU_Name0

[mssms] RE: SQL Query Help with total and count

[Garth Jones]

Try this.,

select
   DS.Name0 as'Computer Name',
   DS.Creation_Date0 as 'Date',
   DS.Operating_System_Name_and0 as 'Operating System',
   OS.Caption0,
   max(OU.System_OU_Name0) as 'OU Name'
FROM
   dbo.v_R_System DS
   Inner Join dbo.v_RA_System_SystemOUName OU on OU.ResourceID = 
DS.ResourceID
   left outer join v_GS_OPERATING_SYSTEM OS on OS.ResourceID = DS.ResourceID
*WHERE
   DS.Operating_System_Name_and0 like '%10%'
   and DateDiff(dd,DS.Creation_Date0, GetDate ()) <= 1
Group BY
   DS.Name0,
   DS.Creation_Date0,
   DS.Operating_System_Name_and0,
   OS.Caption0,
   OU.System_OU_Name0
Order BY
   DS.Name0,
   DS.Creation_Date0,
   DS.Operating_System_Name_and0,
   OS.Caption0,
   OU.System_OU_Name0




Garth Jones
Chief Architect

www.Enhansoft.com<http://www.enhansoft.com/>
[Description: Description: 
cid:image001.jpg@01CC63FB.974F4EC0]<http://www.enhansoft.com/>
Enhancing Your Business
[Description: Description: Description: Description: Description: Description: 
Description: 
cid:image004.png@01CD5E19.F3C3A110]<http://www.enhansoft.com/blog>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image005.png@01CD5E19.F3C3A110]<https://twitter.com/enhansoft>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image006.jpg@01CD5E19.F3C3A110]<http://www.facebook.com/EnhansoftInc>[Description:
 Description: Description: Description: Description: Description: Description: 
Description: Description: Description: Description: Description: Description: 
Description: Description: Enhansoft's YouTube 
Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description: 
Description: Description: Description: Description: Description: 
cid:image007.png@01CD5E19.F3C3A110]<http://myitforum.com/myitforumwp/community/groups/enhansoft/>

Subscribe to Enhansoft's Newsletter!<http://www.enhansoft.com/register>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Boseman, Marcia H - Raleigh, NC
Sent: Wednesday, August 31, 2016 11:04 PM
To: mssms@lists.myitforum.com
Subject: [mssms] SQL Query Help with total and count

I am running the query below and want to remove duplicates and then get a count 
of machines by OU.  Any help would be appreciated
select DS.Name0 [Computer Name],
DS.Creation_Date0 [Date], DS.Operating_System_Name_and0 [Operating System], 
OU.System_OU_Name0 [OU Name]
FROM
dbo.System_DISC DS
Inner Join dbo.System_System_OU_Name_ARR OU on OU.ItemKey = DS.ItemKey
WHERE Operating_System_Name_and0 like '%10%' and
DateDiff(dd,Creation_Date0, GetDate ()) <= 1
Group BY Name0, Creation_Date0, Operating_System_Name_and0, System_OU_Name0

[mssms] RE: Script or tool to document the CM2012 Environment

[Garth Jones]

Hi Henry,

You can find one under the Free tools section on Enhansoft site. 
http://www.enhansoft.com/customer-area




Garth Jones
Chief Architect

www.Enhansoft.com<http://www.enhansoft.com/>
[Description: Description: 
cid:image001.jpg@01CC63FB.974F4EC0]<http://www.enhansoft.com/>
Enhancing Your Business
[Description: Description: Description: Description: Description: Description: 
Description: 
cid:image004.png@01CD5E19.F3C3A110]<http://www.enhansoft.com/blog>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image005.png@01CD5E19.F3C3A110]<https://twitter.com/enhansoft>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image006.jpg@01CD5E19.F3C3A110]<http://www.facebook.com/EnhansoftInc>[Description:
 Description: Description: Description: Description: Description: Description: 
Description: Description: Description: Description: Description: Description: 
Description: Description: Enhansoft's YouTube 
Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description: 
Description: Description: Description: Description: Description: 
cid:image007.png@01CD5E19.F3C3A110]<http://myitforum.com/myitforumwp/community/groups/enhansoft/>

Subscribe to Enhansoft's Newsletter!<http://www.enhansoft.com/register>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of henry.wil...@sanofi.com
Sent: Monday, August 29, 2016 8:06 AM
To: mssms@lists.myitforum.com
Subject: [mssms] Script or tool to document the CM2012 Environment

Hello
I believe there is a tool/script that can enumerate the entire environment and 
create a Word Document with all the configurations / Security, etc. but I can't 
seem to find it - Like to use it (before) our transition to 1511/1606.

Anyone know of this tool/script?

Thanks

RE: [mssms] Remote Console Connect After CAS Recover

[Garth Jones]

Did you re-install the console on any of these remote computers? Exactly what 
error are you getting?



Garth Jones
Chief Architect

www.Enhansoft.com<http://www.enhansoft.com/>
[Description: Description: 
cid:image001.jpg@01CC63FB.974F4EC0]<http://www.enhansoft.com/>
Enhancing Your Business
[Description: Description: Description: Description: Description: Description: 
Description: 
cid:image004.png@01CD5E19.F3C3A110]<http://www.enhansoft.com/blog>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image005.png@01CD5E19.F3C3A110]<https://twitter.com/enhansoft>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image006.jpg@01CD5E19.F3C3A110]<http://www.facebook.com/EnhansoftInc>[Description:
 Description: Description: Description: Description: Description: Description: 
Description: Description: Description: Description: Description: Description: 
Description: Description: Enhansoft's YouTube 
Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description: 
Description: Description: Description: Description: Description: 
cid:image007.png@01CD5E19.F3C3A110]<http://myitforum.com/myitforumwp/community/groups/enhansoft/>

Subscribe to Enhansoft’s Newsletter!<http://www.enhansoft.com/register>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of David Jones
Sent: Wednesday, August 24, 2016 9:32 AM
To: mssms@lists.myitforum.com
Subject: [mssms] Remote Console Connect After CAS Recover

I had to recover our CAS from it's SCCM backup last night. It worked just fine 
and I can connect to the database from the console on the server. But all the 
attempts from multiple computers to connect remotely fail. I looked and found 
the roles are are correct and all the Administrative Users are there and 
correct. I can remote the server as me and open the console. I just cannot 
remote console as me. I did not have to rebuild the server. I did a recovery 
over the top of nonworking CAS. SCCM 2012 R2 sp1. Was CU1 but it won't install 
anymore to this server (says it's already there). The Primaries are still CU1. 
I had to recover from Media not the Start Menu. According to the Site 
Configuration the CAS and Primaries are all 5.00.8239.1000 with the Primaries 
shows as having CU1.

Any suggestions?

Dave

[mssms] Re: Query help

[Garth Jones]

There are a couple thing that you need to look at.


First subselect queries can only have one column.

Secondly, you likely need an Left outer join on the Reg key within the main 
query.

Third, you use always use ResourceID for your "not in"

Fourthly, Understand that the IP address that you are displaying is all KNOWN 
IP address for that system, not just the current IP address.

Fifthly,  Starting with CM12 v_r_system will/can include system that have been 
deleted. user v_R_system_valid instead.


I edited the query by hand, I'm not need my desk so I couldn't test this query, 
so watch out for typos.


SELECT DISTINCT
 sys.NetBIOS_name0 as 'PC Name',
 ip.IP_Addresses0 as 'IP address',
 sys.User_Name0 as 'User Name',
 REG.Value0 as 'Reg Value'
FROM
 dbo.v_r_system_Valid sys
 join dbo.v_RA_System_IPAddresses ip on sys.ResourceID = ip.ResourceID=
 Left outer join dbo.v_GS_Registry_Values0 REG on sys.ResourceID = 
REG.ResourceID
where  sys.ResourceID not in
 (
  SELECT
   sys.ResourceID
  FROM
   dbo.v_r_system_valid sys
   join CM_SC1.dbo.v_RA_System_IPAddresses ip on sys.ResourceID = ip.ResourceID
   join CM_SC1.dbo.v_GS_Registry_Values0 REG on sys.ResourceID = REG.ResourceID
  where
   reg.Value0 like '%Something%'
   and ip.IP_Addresses0 like '10.0%')





From: listsad...@lists.myitforum.com  on behalf 
of David McSpadden 
Sent: Thursday, July 21, 2016 9:17:46 AM
To: Patch Management Mailing List 
(patchmanagem...@listserv.patchmanagement.org); mssms@lists.myitforum.com
Subject: [mssms] Query help

I have this query:
SELECT DISTINCT
sys1.[NetBIOS_name0] ,
ip.IP_Addresses0,
sys1.User_Name0,
REG.Value0
  FROM [CM_SC1].[dbo].[v_r_system] sys1
  join CM_SC1.dbo.v_RA_System_IPAddresses ip on ip.ResourceID=sys1.ResourceID
  join CM_SC1.dbo.v_GS_Registry_Values0 REG on REG.ResourceID=sys1.ResourceID
  where reg.Value0 like '%Something%'
  and ip.IP_Addresses0 like '10.0%'

And it returns all pc that have the registry value of %something%.

I would like to actually get a report of all other workstations that do not 
have this registry value of %something%.
So I thought making the above query a sub query I would get my results.
I however get 0 results:

SELECT DISTINCT
sys1.[NetBIOS_name0] ,
ip.IP_Addresses0,
sys1.User_Name0,
REG.Value0
  FROM [CM_SC1].[dbo].[v_r_system] sys1
  join CM_SC1.dbo.v_RA_System_IPAddresses ip on ip.ResourceID=sys1.ResourceID
  join CM_SC1.dbo.v_GS_Registry_Values0 REG on REG.ResourceID=sys1.ResourceID
  where  ip.IP_Addresses0 not in
  (
SELECT DISTINCT
sys1.[NetBIOS_name0] ,
ip.IP_Addresses0,
sys1.User_Name0,
REG.Value0
  FROM [CM_SC1].[dbo].[v_r_system] sys1
  join CM_SC1.dbo.v_RA_System_IPAddresses ip on ip.ResourceID=sys1.ResourceID
  join CM_SC1.dbo.v_GS_Registry_Values0 REG on REG.ResourceID=sys1.ResourceID
  where reg.Value0 like '%Something%'
  and ip.IP_Addresses0 like '10.0%')




David McSpadden
System Administrator
Indiana Members Credit Union
P: 317.554.8190
[Description: Description: imcu email icon]  [Description: 
Description: facebook email icon]    
[Description: Description: twitter email icon] 


[Description: Description: email logo]
[http://www.amuletsolutions.com/images/mcp.gif]


This e-mail and any files transmitted with it are property of Indiana Members 
Credit Union, are confidential, and are intended solely for the use of the 
individual or entity to whom this e-mail is addressed. If you are not one of 
the named recipient(s) or otherwise have reason to believe that you have 
received this message in error, please notify the sender and delete this 
message immediately from your computer. Any other use, retention, 
dissemination, forwarding, printing, or copying of this email is strictly 
prohibited.


Please consider the environment before printing this email.

[mssms] RE: Software Metering

[Garth Jones]

Happy Canada Day from Canada!

I always tell my clients that it will take ~75 days to start to get useful data 
from all SWM reports.



Garth Jones
Chief Architect

www.Enhansoft.com<http://www.enhansoft.com/>
[Description: Description: 
cid:image001.jpg@01CC63FB.974F4EC0]<http://www.enhansoft.com/>
Enhancing Your Business
[Description: Description: Description: Description: Description: Description: 
Description: 
cid:image004.png@01CD5E19.F3C3A110]<http://www.enhansoft.com/blog>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image005.png@01CD5E19.F3C3A110]<https://twitter.com/enhansoft>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image006.jpg@01CD5E19.F3C3A110]<http://www.facebook.com/EnhansoftInc>[Description:
 Description: Description: Description: Description: Description: Description: 
Description: Description: Description: Description: Description: Description: 
Description: Description: Enhansoft's YouTube 
Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description: 
Description: Description: Description: Description: Description: 
cid:image007.png@01CD5E19.F3C3A110]<http://myitforum.com/myitforumwp/community/groups/enhansoft/>

Subscribe to Enhansoft's Newsletter!<http://www.enhansoft.com/register>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of James Massardo
Sent: Thursday, June 30, 2016 4:22 PM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: Software Metering

In our environment, quite a while. The metering data is summarized monthly so 
it can take several months before you have any meaningful trend data.

Thanks,
James Massardo

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald
Sent: Thursday, June 30, 2016 3:00 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] Software Metering

The e-mail below is from an external source.  Please do not open attachments or 
click links from an unknown or suspicious origin.


If I create a new software metering rule, how long does it take before I can 
pull data/reports in SCCM?



Thank you,



Brian


NOTICE: This electronic mail message and any files transmitted with it are 
intended
exclusively for the individual or entity to which it is addressed. The message,
together with any attachment, may contain confidential and/or privileged 
information.
Any unauthorized review, use, printing, saving, copying, disclosure or 
distribution
is strictly prohibited. If you have received this message in error, please
immediately advise the sender by reply email and delete all copies.

RE: [mssms] Hardware Asset Inventory management with SCCM

[Garth Jones]

My two cents is:

CM is a great product to collect and populate the CMDB. Why have a second 
executable to collect the data from each PC, just to populate the CMDB.
CM is also a great product to help keep the CMDB update. For example Top 
Console User (TCU) and last logon user are great to show who is using the PC 
now. Collect/update Add/Remove Programs data.
Like Sherry, I agree that CM is for current PCs and not for long term offline 
PCs.








Garth Jones
Chief Architect

www.Enhansoft.com<http://www.enhansoft.com/>
[Description: Description: 
cid:image001.jpg@01CC63FB.974F4EC0]<http://www.enhansoft.com/>
Enhancing Your Business
[Description: Description: Description: Description: Description: Description: 
Description: 
cid:image004.png@01CD5E19.F3C3A110]<http://www.enhansoft.com/blog>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image005.png@01CD5E19.F3C3A110]<https://twitter.com/enhansoft>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image006.jpg@01CD5E19.F3C3A110]<http://www.facebook.com/EnhansoftInc>[Description:
 Description: Description: Description: Description: Description: Description: 
Description: Description: Description: Description: Description: Description: 
Description: Description: Enhansoft's YouTube 
Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description: 
Description: Description: Description: Description: Description: 
cid:image007.png@01CD5E19.F3C3A110]<http://myitforum.com/myitforumwp/community/groups/enhansoft/>

Subscribe to Enhansoft’s Newsletter!<http://www.enhansoft.com/register>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Sherry Kissinger
Sent: Wednesday, June 15, 2016 11:04 AM
To: mssms@lists.myitforum.com
Subject: Re: [mssms] Hardware Asset Inventory management with SCCM

My opinion (and it's just an opinion, I could be wrong).  When people ask me 
why they shouldn't use the SCCM database for "asset management" here's what I 
tell them.  ConfigMgr is designed for managing current systems.  If someone 
puts a box in a closet for a year--it's still an Asset, and it's still an asset 
owned by your company.  But it's no longer in the ConfigMgr database.  If you 
were using CM as your "definitive resource for everything about that 
asset"--the info is long gone.

To me, it would make more sense to have/get/create a different database; for 
asset management of physical hardware.  As part of the input, ensure that the 
serial number is in that database.  That way, using SQL reporting, you can tie 
that other database to the CM database, for more robust reporting--but if 
there's a physical asset in the other DB that isn't in CM--at least you still 
know you used to have it... somewhere...  and if that other database hasn't 
been  updated with a notation for "disposed"--you are more likely to assume 
it's in a closet somewhere.

Yes, yes... I know that sometimes when a motherboard is replaced the serial 
number isn't input back--but that's a process issue; and should be able to be 
remediated on the small percentage that happens on.

On Wed, Jun 15, 2016 at 8:29 AM, Daniel Ratliff 
<dratl...@humana.com<mailto:dratl...@humana.com>> wrote:
Sorry, CA SAM for software, CA APM for hardware.

Daniel Ratliff

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>] 
On Behalf Of Daniel Ratliff
Sent: Wednesday, June 15, 2016 9:11 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: RE: [mssms] Hardware Asset Inventory management with SCCM

We use CA SAM. The most difficult part is tieing into the hardware procurement 
system from your PC mfg or reseller. Another difficult piece is tracking stock 
that isn’t deployed yet. SCCM can do neither of these natively.

Daniel Ratliff

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Todd Hemsell
Sent: Wednesday, June 15, 2016 9:03 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: Re: [mssms] Hardware Asset Inventory management with SCCM

Why can't it be the definitive source? That is a silly notion.

On Tue, Jun 14, 2016 at 5:56 PM, Jim Walker 
<jim.wal...@paccar.com<mailto:jim.wal...@paccar.com>> wrote:
Hey folks,
I know this is probably a rehashed topic, but what are some of the good 
products out there you guys are using to compliment SCCM with Hardware 
Inventory? (not software inventory/normalization, but could do both?)
We’re happy with what SCCM tells us, but it can’t be our definitive source of 
information about hardware assets…

_Jim





The information transmitted is intended only for the person or entity

Re: [mssms] Hardware Asset Inventory management with SCCM

[Garth Jones]

And what exactly do you want to know about your hardware?

Sent from my iPhone

On Jun 14, 2016, at 7:03 PM, Jim Walker 
> wrote:

Hey folks,
I know this is probably a rehashed topic, but what are some of the good 
products out there you guys are using to compliment SCCM with Hardware 
Inventory? (not software inventory/normalization, but could do both?)
We're happy with what SCCM tells us, but it can't be our definitive source of 
information about hardware assets...

_Jim

[mssms] RE: OT: Licensing SCCM Distribution Points

[Garth Jones]

They are wrong. There is not if and or buts about it.



Garth Jones
Chief Architect

www.Enhansoft.com<http://www.enhansoft.com/>
[Description: Description: 
cid:image001.jpg@01CC63FB.974F4EC0]<http://www.enhansoft.com/>
Enhancing Your Business
[Description: Description: Description: Description: Description: Description: 
Description: 
cid:image004.png@01CD5E19.F3C3A110]<http://www.enhansoft.com/blog>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image005.png@01CD5E19.F3C3A110]<https://twitter.com/enhansoft>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image006.jpg@01CD5E19.F3C3A110]<http://www.facebook.com/EnhansoftInc>[Description:
 Description: Description: Description: Description: Description: Description: 
Description: Description: Description: Description: Description: Description: 
Description: Description: Enhansoft's YouTube 
Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description: 
Description: Description: Description: Description: Description: 
cid:image007.png@01CD5E19.F3C3A110]<http://myitforum.com/myitforumwp/community/groups/enhansoft/>

Subscribe to Enhansoft's Newsletter!<http://www.enhansoft.com/register>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of David McSpadden
Sent: Friday, June 10, 2016 3:01 PM
To: mssms@lists.myitforum.com
Subject: [mssms] OT: Licensing SCCM Distribution Points

Just got off a call with MS licensing rep(not MS employee) about having to 
license my Branch Distribution Points as System Center servers??

That does not seem true to me?

Anyone have any input on this?

David McSpadden
System Administrator
Indiana Members Credit Union
P: 317.554.8190
[Description: Description: imcu email icon]<http://imcu.com/>  [Description: 
Description: facebook email icon] <https://www.facebook.com/IndianaMembersCU>   
[Description: Description: twitter email icon] 
<https://twitter.com/IndMembersCU>

[Description: Description: email logo]
[http://www.amuletsolutions.com/images/mcp.gif]<http://www.google.com/url?sa=i=j==s=images==rja=8=0ahUKEwjFztf-tePJAhXK5iYKHcPtAxEQjRwIBw=http://www.amuletsolutions.com/awards.aspx=bv.110151844,d.amc=AFQjCNHkrx8CednTEOOq4zUxYyrRUGzUsg=1450459757284499>


This e-mail and any files transmitted with it are property of Indiana Members 
Credit Union, are confidential, and are intended solely for the use of the 
individual or entity to whom this e-mail is addressed. If you are not one of 
the named recipient(s) or otherwise have reason to believe that you have 
received this message in error, please notify the sender and delete this 
message immediately from your computer. Any other use, retention, 
dissemination, forwarding, printing, or copying of this email is strictly 
prohibited.


Please consider the environment before printing this email.

[mssms] RE: All SW Query Help

[Garth Jones]

Add the v_GS_System SQL view.

Declare @CollID char(8)
Set @CollID = 'SMS1'
SELECT
   S.SystemRole0,
   arp.DisplayName0,
   Count(*) AS 'Count',
   arp.Publisher0,
   arp.Version0,
   @CollID as CollectionID
FROM
   dbo.v_R_System_Valid RV
   join dbo.v_Add_Remove_Programs arp on RV.ResourceID = ARP.ResourceID
   JOIN dbo.v_FullCollectionMembership fcm on RV.ResourceID = fcm.ResourceID
   join dbo.v_GS_SYSTEM S on RV.ResourceID = S.ResourceID
WHERE
   fcm.CollectionID = @CollID
GROUP BY
   S.SystemRole0,
   arp.DisplayName0,
   arp.Publisher0,
   arp.Version0
ORDER BY
   S.SystemRole0,
   arp.Publisher0,
   arp.Version0



Garth Jones
Chief Architect

www.Enhansoft.com<http://www.enhansoft.com/>
[Description: Description: 
cid:image001.jpg@01CC63FB.974F4EC0]<http://www.enhansoft.com/>
Enhancing Your Business
[Description: Description: Description: Description: Description: Description: 
Description: 
cid:image004.png@01CD5E19.F3C3A110]<http://www.enhansoft.com/blog>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image005.png@01CD5E19.F3C3A110]<https://twitter.com/enhansoft>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image006.jpg@01CD5E19.F3C3A110]<http://www.facebook.com/EnhansoftInc>[Description:
 Description: Description: Description: Description: Description: Description: 
Description: Description: Description: Description: Description: Description: 
Description: Description: Enhansoft's YouTube 
Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description: 
Description: Description: Description: Description: Description: 
cid:image007.png@01CD5E19.F3C3A110]<http://myitforum.com/myitforumwp/community/groups/enhansoft/>

Subscribe to Enhansoft's Newsletter!<http://www.enhansoft.com/register>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Brian McDonald
Sent: Thursday, June 9, 2016 2:22 PM
To: mssms@lists.myitforum.com
Subject: [mssms] All SW Query Help


Hello all,



I'm trying to gather a report of all Software in Add or Remove Programs from 
SCCM. I need to identify which servers or workstations have the software 
installed. I understand this is going to generate numerous rows per computer, 
but this is what has been asked by management. Note, we are closer to 
purchasing 3rd party software to assist with the normalization of this data. 
But, for now, I have to work with what I have.



Here is the baseline query I am using:


Declare @CollID char(8)
Set @CollID = 'SMS1'
SELECT DisplayName0, Count(*) AS 'Count', Publisher0, Version0, @CollID as 
CollectionID
FROM v_Add_Remove_Programs arp
JOIN v_FullCollectionMembership fcm on arp.ResourceID=fcm.ResourceID
WHERE fcm.CollectionID = @CollID
GROUP BY DisplayName0, Publisher0, Version0
ORDER BY Publisher0, Version0



Can someone please tell me how I can modify the above query to include the 
servers or workstations that have the software installed?



Thanks,

Brian

RE: [mssms] RE: Query Help

[Garth Jones]

I will minus on that CM SQL view.

The reason is simple, that V_GS_INSTALLED_SOFTWARE does not show everything 
that is possible installed, for that matter it will hide some software title 
which are listed within ARP like Microsoft SQL server 2014.

You can read my blog on the subject.
http://www.enhansoft.com/blog/configuration-manager-and-asset-intelligence




Garth Jones
Chief Architect

www.Enhansoft.com<http://www.enhansoft.com/>
[Description: Description: 
cid:image001.jpg@01CC63FB.974F4EC0]<http://www.enhansoft.com/>
Enhancing Your Business
[Description: Description: Description: Description: Description: Description: 
Description: 
cid:image004.png@01CD5E19.F3C3A110]<http://www.enhansoft.com/blog>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image005.png@01CD5E19.F3C3A110]<https://twitter.com/enhansoft>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image006.jpg@01CD5E19.F3C3A110]<http://www.facebook.com/EnhansoftInc>[Description:
 Description: Description: Description: Description: Description: Description: 
Description: Description: Description: Description: Description: Description: 
Description: Description: Enhansoft's YouTube 
Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description: 
Description: Description: Description: Description: Description: 
cid:image007.png@01CD5E19.F3C3A110]<http://myitforum.com/myitforumwp/community/groups/enhansoft/>

Subscribe to Enhansoft's Newsletter!<http://www.enhansoft.com/register>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Stephen Leuthold
Sent: Friday, June 3, 2016 1:21 PM
To: mssms@lists.myitforum.com
Subject: Re: [mssms] RE: Query Help

PLUS ONE for V_GS_INSTALLED_SOFTWARE !

-Stephen

On Jun 3, 2016, at 11:29 AM, Todd Hemsell 
<hems...@gmail.com<mailto:hems...@gmail.com>> wrote:
V_GS_INSTALLED_SOFTWARE is far superior to any of that.

On Thu, Jun 2, 2016 at 12:07 PM, Murray, Mike 
<mmur...@csuchico.edu<mailto:mmur...@csuchico.edu>> wrote:
I think you'll want to look at Installed Applications instead. There's also an 
Installed Applications (64).



From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>] 
On Behalf Of Brian McDonald
Sent: Thursday, June 2, 2016 6:47 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] Re: Query Help


Yes. Problem is several of these names aren't coming up when I search the 
Parameter Value under Computers with a specific product.



Example of a few include: HTMLDOC, Lotus Domino, ClearingHouse, CVE-2013-1347, 
ImageRight Desktop, ImageRightPrinter and more...



Here is the SQL query I'm using:



eclare @CollID char(8)
Set @CollID = 'SMS1'
SELECT DisplayName0, Count(*) AS 'Count', Publisher0, Version0, @CollID as 
CollectionID
FROM v_Add_Remove_Programs arp
JOIN v_FullCollectionMembership fcm on arp.ResourceID=fcm.ResourceID
WHERE fcm.CollectionID = @CollID
GROUP BY DisplayName0, Publisher0, Version0
ORDER BY Publisher0, Version0


From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
<listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>> on 
behalf of Garth Jones <ga...@enhansoft.com<mailto:ga...@enhansoft.com>>
Sent: Wednesday, June 1, 2016 3:45:04 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] RE: Query Help

Have you looked at the built-in reports for this yet?



Garth Jones
Chief Architect

www.Enhansoft.com<http://www.enhansoft.com/>
<http://www.enhansoft.com/>
Enhancing Your Business
<http://www.enhansoft.com/blog><https://twitter.com/enhansoft><http://www.facebook.com/EnhansoftInc><http://www.youtube.com/user/Enhansoft/videos><http://myitforum.com/myitforumwp/community/groups/enhansoft/>

Subscribe to Enhansoft's Newsletter!<http://www.enhansoft.com/register>

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald
Sent: Wednesday, June 1, 2016 4:02 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] Query Help


Hello,



Management has provided me a list of applications they're researching and would 
like to know which devices have these applications have. Is there a SQL query I 
could use as a template and re-use it by modifying the DisplayName?



For example, one of the apps in question is 'AOL Toolbar'.



Can someone provide an example of a query I could use for this task? And make 
modifications to the query based on the name?



Thanks,

Brian

[mssms] RE: Query Help

[Garth Jones]

Have you looked at the built-in reports for this yet?



Garth Jones
Chief Architect

www.Enhansoft.com<http://www.enhansoft.com/>
[Description: Description: 
cid:image001.jpg@01CC63FB.974F4EC0]<http://www.enhansoft.com/>
Enhancing Your Business
[Description: Description: Description: Description: Description: Description: 
Description: 
cid:image004.png@01CD5E19.F3C3A110]<http://www.enhansoft.com/blog>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image005.png@01CD5E19.F3C3A110]<https://twitter.com/enhansoft>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image006.jpg@01CD5E19.F3C3A110]<http://www.facebook.com/EnhansoftInc>[Description:
 Description: Description: Description: Description: Description: Description: 
Description: Description: Description: Description: Description: Description: 
Description: Description: Enhansoft's YouTube 
Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description: 
Description: Description: Description: Description: Description: 
cid:image007.png@01CD5E19.F3C3A110]<http://myitforum.com/myitforumwp/community/groups/enhansoft/>

Subscribe to Enhansoft's Newsletter!<http://www.enhansoft.com/register>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Brian McDonald
Sent: Wednesday, June 1, 2016 4:02 PM
To: mssms@lists.myitforum.com
Subject: [mssms] Query Help


Hello,



Management has provided me a list of applications they're researching and would 
like to know which devices have these applications have. Is there a SQL query I 
could use as a template and re-use it by modifying the DisplayName?



For example, one of the apps in question is 'AOL Toolbar'.



Can someone provide an example of a query I could use for this task? And make 
modifications to the query based on the name?



Thanks,

Brian

[mssms] RE: Application Catalog Usage

[Garth Jones]

BTW, Packages work in the App Catalog.




Garth Jones
Chief Architect

www.Enhansoft.com<http://www.enhansoft.com/>
[Description: Description: 
cid:image001.jpg@01CC63FB.974F4EC0]<http://www.enhansoft.com/>
Enhancing Your Business
[Description: Description: Description: Description: Description: Description: 
Description: 
cid:image004.png@01CD5E19.F3C3A110]<http://www.enhansoft.com/blog>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image005.png@01CD5E19.F3C3A110]<https://twitter.com/enhansoft>[Description: 
Description: Description: Description: Description: Description: Description: 
cid:image006.jpg@01CD5E19.F3C3A110]<http://www.facebook.com/EnhansoftInc>[Description:
 Description: Description: Description: Description: Description: Description: 
Description: Description: Description: Description: Description: Description: 
Description: Description: Enhansoft's YouTube 
Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description: 
Description: Description: Description: Description: Description: 
cid:image007.png@01CD5E19.F3C3A110]<http://myitforum.com/myitforumwp/community/groups/enhansoft/>

Subscribe to Enhansoft's Newsletter!<http://www.enhansoft.com/register>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of henry.wil...@sanofi.com
Sent: Wednesday, June 1, 2016 9:06 AM
To: mssms@lists.myitforum.com
Subject: [mssms] Application Catalog Usage

Just wondering if anyone has implemented the Application Catalog?

We haven't started creating Applications yet (still packages only) but that is 
a future requirement.

Just looking to see if this is being widely used.

Thanks

Re: [mssms] SCCM PowerShell to pull report information

[Garth Jones]

Or for that matter have you looked at updating David script?

Sent from my iPhone

On May 26, 2016, at 4:32 PM, James Avery 
> wrote:

Thank you Sherry!!

I’m going to take the scripts you gave me and try to get the other information 
from SCCM.

Do you know a good way to take Garth’s VBS script and port it to Powershell?

James

From: listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Sherry Kissinger
Sent: Thursday, May 26, 2016 10:52 AM
To: mssms@lists.myitforum.com
Subject: Re: [mssms] SCCM PowerShell to pull report information

sample...

$listAdContainers = (get-cmdiscoveryMethod -name 
ActiveDirectorySystemDiscovery).proplists | where-Object {$_.PropertyListName 
-eq "AD Containers"}
($listAdContainers.values -like 'ldap*')

On Thu, May 26, 2016 at 10:14 AM, Sherry Kissinger 
> wrote:
AD containers are in  (get-cmdiscoverymethod -name 
activedirectorysystemdiscovery).proplists
, not props.  I'm guessing because those types of properties could be a "list 
of" things.

On Thu, May 26, 2016 at 9:33 AM, James Avery 
> wrote:

That makes sense and I can kinda parse out what should go where. There are a 
few things it's not showing. For example the Active Directory Containers.



Here's what I see when I run your script, in case anyone wants to see it.



PS QTC:\> (get-cmdiscoverymethod -name activedirectorysystemdiscovery).props

SmsProviderObjectPath : SMS_EmbeddedProperty
ItemType  :
PropertyName  : Enable Incremental Sync
Value : 1
Value1:
Value2:

SmsProviderObjectPath : SMS_EmbeddedProperty
ItemType  :
PropertyName  : Startup Schedule
Value : 0
Value1: 00012010A000
Value2:

SmsProviderObjectPath : SMS_EmbeddedProperty
ItemType  :
PropertyName  : Full Sync Schedule
Value : 0
Value1: 000117100038
Value2:

SmsProviderObjectPath : SMS_EmbeddedProperty
ItemType  :
PropertyName  : SETTINGS
Value : 0
Value1: ACTIVE
Value2:

SmsProviderObjectPath : SMS_EmbeddedProperty
ItemType  :
PropertyName  : Run Count
Value : 5
Value1:
Value2:

SmsProviderObjectPath : SMS_EmbeddedProperty
ItemType  :
PropertyName  : Enable Filtering Expired Logon
Value : 0
Value1:
Value2:

SmsProviderObjectPath : SMS_EmbeddedProperty
ItemType  :
PropertyName  : Days Since Last Logon
Value : 90
Value1:
Value2:

SmsProviderObjectPath : SMS_EmbeddedProperty
ItemType  :
PropertyName  : Enable Filtering Expired Password
Value : 0
Value1:
Value2:

SmsProviderObjectPath : SMS_EmbeddedProperty
ItemType  :
PropertyName  : Days Since Last Password Set


From: listsad...@lists.myitforum.com 
> on 
behalf of Sherry Kissinger 
>
Sent: Wednesday, May 25, 2016 7:08:15 PM
To: mssms@lists.myitforum.com
Subject: Re: [mssms] SCCM PowerShell to pull report information

(get-cmdiscoverymethod -name ActiveDirectoryUserDiscovery).props
and/or
(get-cmdiscoverymethod -name ActiveDirectoryUserDiscovery).proplists

Does that make more sense for output ?


On Wed, May 25, 2016 at 3:21 PM, James Avery 
> wrote:
I’m trying to get more information for reports other than what Garth and David 
O. wrote.



I'm trying to pull information for a report I'm building.
I was thinking of starting with
Get-CMDiscoveryMethod -Name "ActiveDirectoryForestDiscovery"
Get-CMDiscoveryMethod -Name "ActiveDirectoryGroupDiscovery"
Get-CMDiscoveryMethod -Name "ActiveDirectorySystemDiscovery"
Get-CMDiscoveryMethod -Name "ActiveDirectoryUserDiscovery"
Get-CMDiscoveryMethod -Name "HeartbeatDiscovery"
Get-CMDiscoveryMethod -Name "NetworkForestDiscovery"
However, I get something like this.
PS LAB:\> Get-CMDiscoveryMethod -Name "ActiveDirectoryUserDiscovery"


SmsProviderObjectPath : 
SMS_SCI_Component.FileType=2,ItemName="SMS_AD_USER_DISCOVERY_AGENT|SCCM-01.home.pvt",ItemType="
Component",SiteCode="LAB"
ComponentName : SMS_AD_USER_DISCOVERY_AGENT
FileType  : 2
Flag  : 6
ItemName  : 

Re: [mssms] SCCM PowerShell to pull report information

[Garth Jones]

So what wrong with my script?

Sent from my iPhone

On May 26, 2016, at 4:32 PM, James Avery 
> wrote:

Thank you Sherry!!

I’m going to take the scripts you gave me and try to get the other information 
from SCCM.

Do you know a good way to take Garth’s VBS script and port it to Powershell?

James

From: listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Sherry Kissinger
Sent: Thursday, May 26, 2016 10:52 AM
To: mssms@lists.myitforum.com
Subject: Re: [mssms] SCCM PowerShell to pull report information

sample...

$listAdContainers = (get-cmdiscoveryMethod -name 
ActiveDirectorySystemDiscovery).proplists | where-Object {$_.PropertyListName 
-eq "AD Containers"}
($listAdContainers.values -like 'ldap*')

On Thu, May 26, 2016 at 10:14 AM, Sherry Kissinger 
> wrote:
AD containers are in  (get-cmdiscoverymethod -name 
activedirectorysystemdiscovery).proplists
, not props.  I'm guessing because those types of properties could be a "list 
of" things.

On Thu, May 26, 2016 at 9:33 AM, James Avery 
> wrote:

That makes sense and I can kinda parse out what should go where. There are a 
few things it's not showing. For example the Active Directory Containers.



Here's what I see when I run your script, in case anyone wants to see it.



PS QTC:\> (get-cmdiscoverymethod -name activedirectorysystemdiscovery).props

SmsProviderObjectPath : SMS_EmbeddedProperty
ItemType  :
PropertyName  : Enable Incremental Sync
Value : 1
Value1:
Value2:

SmsProviderObjectPath : SMS_EmbeddedProperty
ItemType  :
PropertyName  : Startup Schedule
Value : 0
Value1: 00012010A000
Value2:

SmsProviderObjectPath : SMS_EmbeddedProperty
ItemType  :
PropertyName  : Full Sync Schedule
Value : 0
Value1: 000117100038
Value2:

SmsProviderObjectPath : SMS_EmbeddedProperty
ItemType  :
PropertyName  : SETTINGS
Value : 0
Value1: ACTIVE
Value2:

SmsProviderObjectPath : SMS_EmbeddedProperty
ItemType  :
PropertyName  : Run Count
Value : 5
Value1:
Value2:

SmsProviderObjectPath : SMS_EmbeddedProperty
ItemType  :
PropertyName  : Enable Filtering Expired Logon
Value : 0
Value1:
Value2:

SmsProviderObjectPath : SMS_EmbeddedProperty
ItemType  :
PropertyName  : Days Since Last Logon
Value : 90
Value1:
Value2:

SmsProviderObjectPath : SMS_EmbeddedProperty
ItemType  :
PropertyName  : Enable Filtering Expired Password
Value : 0
Value1:
Value2:

SmsProviderObjectPath : SMS_EmbeddedProperty
ItemType  :
PropertyName  : Days Since Last Password Set


From: listsad...@lists.myitforum.com 
> on 
behalf of Sherry Kissinger 
>
Sent: Wednesday, May 25, 2016 7:08:15 PM
To: mssms@lists.myitforum.com
Subject: Re: [mssms] SCCM PowerShell to pull report information

(get-cmdiscoverymethod -name ActiveDirectoryUserDiscovery).props
and/or
(get-cmdiscoverymethod -name ActiveDirectoryUserDiscovery).proplists

Does that make more sense for output ?


On Wed, May 25, 2016 at 3:21 PM, James Avery 
> wrote:
I’m trying to get more information for reports other than what Garth and David 
O. wrote.



I'm trying to pull information for a report I'm building.
I was thinking of starting with
Get-CMDiscoveryMethod -Name "ActiveDirectoryForestDiscovery"
Get-CMDiscoveryMethod -Name "ActiveDirectoryGroupDiscovery"
Get-CMDiscoveryMethod -Name "ActiveDirectorySystemDiscovery"
Get-CMDiscoveryMethod -Name "ActiveDirectoryUserDiscovery"
Get-CMDiscoveryMethod -Name "HeartbeatDiscovery"
Get-CMDiscoveryMethod -Name "NetworkForestDiscovery"
However, I get something like this.
PS LAB:\> Get-CMDiscoveryMethod -Name "ActiveDirectoryUserDiscovery"


SmsProviderObjectPath : 
SMS_SCI_Component.FileType=2,ItemName="SMS_AD_USER_DISCOVERY_AGENT|SCCM-01.home.pvt",ItemType="
Component",SiteCode="LAB"
ComponentName : SMS_AD_USER_DISCOVERY_AGENT
FileType  : 2
Flag  : 6
ItemName  : SMS_AD_USER_DISCOVERY_AGENT|SCCM-01.home.pvt

[mssms] RE: Hinv not running as scheduled

[Garth Jones]

I did a few things for Deep Freeze computers...


1.  Created a package with batch file using those commands, This get 
deployed to the computer exactly at the beginning of their maintenance window.

2.  We avoided SW inventory like the plague on these computers as it can 
take up all of the MW time for just SW inv.

3.  We had more than one MW a week. This was due to both SU, App deployment 
and Inventory happening.

4.  On a few select computer, we used the Task Scheduler too

This will not stop the re-sync but it will mean that the inventory is no more 
than a few data old.



From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Corkill, Daniel
Sent: Monday, May 9, 2016 1:42 AM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: Hinv not running as scheduled

Hi Garth,

I haven't reviewed the dataldr.log on the clients because I'm not seeing 
adequate data in the inventoryagent.log. Essentially it's about a half and half 
situation - half the clients did not run a hinv on Sunday, according to the 
inventoryagent.log. On these clients I opened and merged all the CM logs to 
confirm there was other client activity on Sunday, just no hinv. The other half 
did run a hinv on Sunday but it was at 9am instead of 10am. I can see the hinv 
occurring in the inventoryagent.log at 9am and then nothing for the rest of the 
day (except a DDR).

I'm expecting the hinvs to be deltas because when I installed the CM client the 
machine was thawed so my expectation is the client will know a full inventory 
has been performed and every Sunday during the thaw period it will perform a 
delta and know about it.

I've read your article, am I best to implement your method?

Daniel.

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones
Sent: Monday, 9 May 2016 1:16 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] RE: Hinv not running as scheduled

Hi Daniel, there is lots is things to look at:


1.  Did you look at the client's log file to confirm that HW invent has 
taken place.

2.  Are you forcing a full HW inv each time?

3.  Did you review the dataldr.log to see if the HW inv is getting reject 
and a re-sync notice occurs.

4.  This blog post is more or less what I have used for deep freeze 
computers 
http://www.enhansoft.com/blog/how-to-avoid-receiving-inventory-re-sync-requests-for-snapshot-vms




From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Corkill, Daniel
Sent: Sunday, May 8, 2016 9:30 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] Hinv not running as scheduled

I applied a custom client settings to a small collection of systems late last 
week that schedules a hinv for every Sunday at 10:01am. Checking this morning 
(Monday) and I can report that none were successful. It's a combination of the 
hinv wasn't run at all on the Sunday (despite confirming the machine was on) 
and the hinv running on Sunday but not at the scheduled time (~1 hour before 
the scheduled time).

These machines are using Deep Freeze with a thaw period specified for every 
Sunday 9am - 5pm for maintenance and are configured to power on at 8am daily 
and shutdown at 6pm. When I installed the CM client on these machines last week 
I ensured they were thawed and had received policies so I'm not sure what's 
going on here.

Any thoughts?




*

This email, including any attachment, is confidential to the intended 
recipient.  It may also be privileged and may be subject to copyright.  If you 
have received this email in error, please notify the sender immediately and 
delete all copies of the email.  Any confidentiality or privilege is not 
waived.  Neither the Council nor the sender warrant that this email does not 
contain any viruses or other unsolicited items.



This email is an informal Council communication.  The Council only accepts 
responsibility for information sent under official letterhead and duly signed 
by, or on behalf of, the Chief Executive Officer.



Privacy Collection Notice

Logan City Council may collect your personal information, e.g. name, 
residential address, phone number etc, in order to conduct its business and/or 
meet its statutory obligations. The information will only be accessed by 
employees and/or Councillors of Logan City Council for Council business related 
activities only. If your personal information will be passed onto a third 
party, Council will advise you of this disclosure, the purpose of the 
disclosure and reason why. Your information will not be given to any other 
person or agency unless you have given us permission o

[mssms] RE: Hinv not running as scheduled

[Garth Jones]

Hi Daniel, there is lots is things to look at:


1.  Did you look at the client's log file to confirm that HW invent has 
taken place.

2.  Are you forcing a full HW inv each time?

3.  Did you review the dataldr.log to see if the HW inv is getting reject 
and a re-sync notice occurs.

4.  This blog post is more or less what I have used for deep freeze 
computers 
http://www.enhansoft.com/blog/how-to-avoid-receiving-inventory-re-sync-requests-for-snapshot-vms




From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Corkill, Daniel
Sent: Sunday, May 8, 2016 9:30 PM
To: mssms@lists.myitforum.com
Subject: [mssms] Hinv not running as scheduled

I applied a custom client settings to a small collection of systems late last 
week that schedules a hinv for every Sunday at 10:01am. Checking this morning 
(Monday) and I can report that none were successful. It's a combination of the 
hinv wasn't run at all on the Sunday (despite confirming the machine was on) 
and the hinv running on Sunday but not at the scheduled time (~1 hour before 
the scheduled time).

These machines are using Deep Freeze with a thaw period specified for every 
Sunday 9am - 5pm for maintenance and are configured to power on at 8am daily 
and shutdown at 6pm. When I installed the CM client on these machines last week 
I ensured they were thawed and had received policies so I'm not sure what's 
going on here.

Any thoughts?




*

This email, including any attachment, is confidential to the intended 
recipient.  It may also be privileged and may be subject to copyright.  If you 
have received this email in error, please notify the sender immediately and 
delete all copies of the email.  Any confidentiality or privilege is not 
waived.  Neither the Council nor the sender warrant that this email does not 
contain any viruses or other unsolicited items.



This email is an informal Council communication.  The Council only accepts 
responsibility for information sent under official letterhead and duly signed 
by, or on behalf of, the Chief Executive Officer.



Privacy Collection Notice

Logan City Council may collect your personal information, e.g. name, 
residential address, phone number etc, in order to conduct its business and/or 
meet its statutory obligations. The information will only be accessed by 
employees and/or Councillors of Logan City Council for Council business related 
activities only. If your personal information will be passed onto a third 
party, Council will advise you of this disclosure, the purpose of the 
disclosure and reason why. Your information will not be given to any other 
person or agency unless you have given us permission or we are required by law.

[mssms] RE: Help with SQL for report

[Garth Jones]

Here is a cleanup fixed up and following best practices version of this query.

select  distinct
   RV.ResourceID,
   BIOS.SerialNumber0,
   SEU.SMBIOSAssetTag0,
   RV.Netbios_Name0,
   RV.Client_Version0,
   RV.Distinguished_Name0,
   OS.Caption0,
   OS.CSDVersion0,
   RV.Last_Logon_Timestamp0,
   WS.LastHWScan,
   CS.Manufacturer0,
   CS.Model0,
   CS.TotalPhysicalMemory0,
   OS.InstallDate0,
   OS.LastBootUpTime0,
   SCU.TopConsoleUser0,
   RV.User_Name0,RV.User_Domain0,
   BIOS.SMBIOSBIOSVersion0,
   EV.DriveLetter0,
   EV.ProtectionStatus0,
   OS.Description0,
   RV.Description0
from
   dbo.v_R_System AS RV
   LEFT OUTER JOIN dbo.v_RA_System_SystemOUName AS RASSOUN ON RV.ResourceID 
= RASSOUN.ResourceID
   LEFT OUTER JOIN dbo.v_GS_COMPUTER_SYSTEM AS CS ON CS.ResourceID = 
RV.ResourceID
   LEFT OUTER JOIN dbo.v_GS_OPERATING_SYSTEM AS OS ON OS.ResourceID = 
RV.ResourceID
   LEFT OUTER JOIN dbo.v_GS_PC_BIOS AS BIOS ON BIOS.ResourceID = 
RV.ResourceID
   LEFT OUTER JOIN dbo.v_GS_SYSTEM_CONSOLE_USAGE AS SCU ON SCU.ResourceID = 
RV.ResourceID
   LEFT OUTER JOIN dbo.v_GS_ENCRYPTABLE_VOLUME AS EV ON EV.ResourceID = 
RV.ResourceID
   LEFT OUTER JOIN dbo.v_GS_WORKSTATION_STATUS AS WS ON WS.ResourceID = 
RV.ResourceID
   left outer join dbo.v_GS_SYSTEM_ENCLOSURE_UNIQUE SEU ON RV.ResourceID = 
SEU.ResourceID
order by
   RV.Netbios_Name0





From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Atkinson, Matt T
Sent: Tuesday, March 24, 2015 2:41 PM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: Help with SQL for report

I also tried to run it in SSMS and it looks like some of the column names are 
incorrect:
SMS_R_System.operatingSystem0 should be 
SMS_R_System.Operating_System_Name_And0, etc.
[cid:image001.png@01D06644.150060E0]

From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Murray, Mike
Sent: Tuesday, March 24, 2015 11:23 AM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: [mssms] Help with SQL for report

I'm trying to use this to create a report. When I run the report, I get:


  *   An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand)


Here's the SQL:

select  distinct 
SMS_R_System.ItemKey,SMS_G_System_PC_BIOS.SerialNumber00,v_GS_SYSTEM_ENCLOSURE_UNIQUE.AssetTag,SMS_R_System.Name0,SMS_R_System.Client_Version0,SMS_R_System.Distinguished_Name0,SMS_R_System.operatingSystem0,SMS_R_System.operatingSystemServicePac0,SMS_R_System.Last_Logon_Timestamp0,___System_WORKSTATION_STATUS3.LastHWScan,SMS_G_System_COMPUTER_SYSTEM.Manufacturer00,SMS_G_System_COMPUTER_SYSTEM.Model00,SMS_G_System_COMPUTER_SYSTEM.TotalPhysicalMemory00,SMS_G_System_OPERATING_SYSTEM.InstallDate00,SMS_G_System_OPERATING_SYSTEM.LastBootUpTime00,__ystem_SYSTEM_CONSOLE_USAGE1.TopConsoleUser00,SMS_R_System.User_Name0,SMS_R_System.User_Domain0,SMS_G_System_PC_BIOS.SMBIOSBIOSVersion00,___System_ENCRYPTABLE_VOLUME2.DriveLetter00,___System_ENCRYPTABLE_VOLUME2.ProtectionStatus00,SMS_G_System_OPERATING_SYSTEM.Description00,SMS_R_System.description0
from vSMS_R_System AS SMS_R_System LEFT OUTER JOIN System_System_OU_Name_ARR AS 
__mSystem_System_OU_Name_ARR0 ON SMS_R_System.ItemKey = 
__mSystem_System_OU_Name_ARR0.ItemKey  LEFT OUTER JOIN Computer_System_DATA AS 
SMS_G_System_COMPUTER_SYSTEM ON SMS_G_System_COMPUTER_SYSTEM.MachineID = 
SMS_R_System.ItemKey  LEFT OUTER JOIN Operating_System_DATA AS 
SMS_G_System_OPERATING_SYSTEM ON SMS_G_System_OPERATING_SYSTEM.MachineID = 
SMS_R_System.ItemKey  LEFT OUTER JOIN PC_BIOS_DATA AS SMS_G_System_PC_BIOS ON 
SMS_G_System_PC_BIOS.MachineID = SMS_R_System.ItemKey  LEFT OUTER JOIN 
SYSTEM_CONSOLE_USAGE_DATA AS __ystem_SYSTEM_CONSOLE_USAGE1 ON 
__ystem_SYSTEM_CONSOLE_USAGE1.MachineID = SMS_R_System.ItemKey  LEFT OUTER JOIN 
ENCRYPTABLE_VOLUME_DATA AS ___System_ENCRYPTABLE_VOLUME2 ON 
___System_ENCRYPTABLE_VOLUME2.MachineID = SMS_R_System.ItemKey LEFT OUTER JOIN 
WorkstationStatus_DATA AS ___System_WORKSTATION_STATUS3 ON 
___System_WORKSTATION_STATUS3.MachineID = SMS_R_System.ItemKey
where (SMS_R_System.Obsolete0 = N'0') order by name0



Best Regards,

Mike Murray
Desktop Management Coordinator - IT Support Services
California State University, Chico
530.898.4357
mmur...@csuchico.edumailto:mmur...@csuchico.edu





This message is intended for the sole use of the addressee, and may contain 
information that is privileged, confidential and exempt from disclosure under 
applicable law. If you are not the addressee you are hereby notified that you 
may not use, copy, disclose, or distribute to anyone the message or any 
information contained in the message. If you have received this message in 
error, please immediately advise the 

[mssms] RE: Help with SQL for report

[Garth Jones]

Where exactly are you seeing that... I ran this query within SSMS and it run 
without any errors, so help me understand what you are trying to do.


From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Murray, Mike
Sent: Tuesday, March 24, 2015 3:25 PM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: Help with SQL for report

Hi Garth, thank you! I'm getting this error when I save or run: An item with 
the same key has already been added

Thanks,

Mike

From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones
Sent: Tuesday, March 24, 2015 12:07 PM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: [mssms] RE: Help with SQL for report

Here is a cleanup fixed up and following best practices version of this query.

select  distinct
   RV.ResourceID,
   BIOS.SerialNumber0,
   SEU.SMBIOSAssetTag0,
   RV.Netbios_Name0,
   RV.Client_Version0,
   RV.Distinguished_Name0,
   OS.Caption0,
   OS.CSDVersion0,
   RV.Last_Logon_Timestamp0,
   WS.LastHWScan,
   CS.Manufacturer0,
   CS.Model0,
   CS.TotalPhysicalMemory0,
   OS.InstallDate0,
   OS.LastBootUpTime0,
   SCU.TopConsoleUser0,
   RV.User_Name0,RV.User_Domain0,
   BIOS.SMBIOSBIOSVersion0,
   EV.DriveLetter0,
   EV.ProtectionStatus0,
   OS.Description0,
   RV.Description0
from
   dbo.v_R_System AS RV
   LEFT OUTER JOIN dbo.v_RA_System_SystemOUName AS RASSOUN ON RV.ResourceID 
= RASSOUN.ResourceID
   LEFT OUTER JOIN dbo.v_GS_COMPUTER_SYSTEM AS CS ON CS.ResourceID = 
RV.ResourceID
   LEFT OUTER JOIN dbo.v_GS_OPERATING_SYSTEM AS OS ON OS.ResourceID = 
RV.ResourceID
   LEFT OUTER JOIN dbo.v_GS_PC_BIOS AS BIOS ON BIOS.ResourceID = 
RV.ResourceID
   LEFT OUTER JOIN dbo.v_GS_SYSTEM_CONSOLE_USAGE AS SCU ON SCU.ResourceID = 
RV.ResourceID
   LEFT OUTER JOIN dbo.v_GS_ENCRYPTABLE_VOLUME AS EV ON EV.ResourceID = 
RV.ResourceID
   LEFT OUTER JOIN dbo.v_GS_WORKSTATION_STATUS AS WS ON WS.ResourceID = 
RV.ResourceID
   left outer join dbo.v_GS_SYSTEM_ENCLOSURE_UNIQUE SEU ON RV.ResourceID = 
SEU.ResourceID
order by
   RV.Netbios_Name0





From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Atkinson, Matt T
Sent: Tuesday, March 24, 2015 2:41 PM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: [mssms] RE: Help with SQL for report

I also tried to run it in SSMS and it looks like some of the column names are 
incorrect:
SMS_R_System.operatingSystem0 should be 
SMS_R_System.Operating_System_Name_And0, etc.
[cid:image001.png@01D06649.6EFAA470]

From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Murray, Mike
Sent: Tuesday, March 24, 2015 11:23 AM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: [mssms] Help with SQL for report

I'm trying to use this to create a report. When I run the report, I get:


  *   An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand)


Here's the SQL:

select  distinct 
SMS_R_System.ItemKey,SMS_G_System_PC_BIOS.SerialNumber00,v_GS_SYSTEM_ENCLOSURE_UNIQUE.AssetTag,SMS_R_System.Name0,SMS_R_System.Client_Version0,SMS_R_System.Distinguished_Name0,SMS_R_System.operatingSystem0,SMS_R_System.operatingSystemServicePac0,SMS_R_System.Last_Logon_Timestamp0,___System_WORKSTATION_STATUS3.LastHWScan,SMS_G_System_COMPUTER_SYSTEM.Manufacturer00,SMS_G_System_COMPUTER_SYSTEM.Model00,SMS_G_System_COMPUTER_SYSTEM.TotalPhysicalMemory00,SMS_G_System_OPERATING_SYSTEM.InstallDate00,SMS_G_System_OPERATING_SYSTEM.LastBootUpTime00,__ystem_SYSTEM_CONSOLE_USAGE1.TopConsoleUser00,SMS_R_System.User_Name0,SMS_R_System.User_Domain0,SMS_G_System_PC_BIOS.SMBIOSBIOSVersion00,___System_ENCRYPTABLE_VOLUME2.DriveLetter00,___System_ENCRYPTABLE_VOLUME2.ProtectionStatus00,SMS_G_System_OPERATING_SYSTEM.Description00,SMS_R_System.description0
from vSMS_R_System AS SMS_R_System LEFT OUTER JOIN System_System_OU_Name_ARR AS 
__mSystem_System_OU_Name_ARR0 ON SMS_R_System.ItemKey = 
__mSystem_System_OU_Name_ARR0.ItemKey  LEFT OUTER JOIN Computer_System_DATA AS 
SMS_G_System_COMPUTER_SYSTEM ON SMS_G_System_COMPUTER_SYSTEM.MachineID = 
SMS_R_System.ItemKey  LEFT OUTER JOIN Operating_System_DATA AS 
SMS_G_System_OPERATING_SYSTEM ON SMS_G_System_OPERATING_SYSTEM.MachineID = 
SMS_R_System.ItemKey  LEFT OUTER JOIN PC_BIOS_DATA AS SMS_G_System_PC_BIOS ON 
SMS_G_System_PC_BIOS.MachineID = SMS_R_System.ItemKey  LEFT OUTER JOIN 
SYSTEM_CONSOLE_USAGE_DATA AS __ystem_SYSTEM_CONSOLE_USAGE1 ON 
__ystem_SYSTEM_CONSOLE_USAGE1.MachineID = SMS_R_System.ItemKey  LEFT OUTER JOIN 
ENCRYPTABLE_VOLUME_DATA AS ___System_ENCRYPTABLE_VOLUME2 ON 
___System_ENCRYPTABLE_VOLUME2.MachineID

RE: [mssms] RE: Which of these options would cause the least impact on our site server?

[Garth Jones]

IMO, I wouldn't bothered with BITS throttling, instead, get your network team 
to setup QOS to set BITS protocol as lower priority than everything else. This 
way applications get to the edit user as fast as possible, without cause any 
network issues.


From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Atkinson, Matt T
Sent: Tuesday, March 24, 2015 1:50 PM
To: mssms@lists.myitforum.com
Subject: RE: [mssms] RE: Which of these options would cause the least impact on 
our site server?

Thanks Jason, in my situation we've got a query already created for every 
boundary that exists in SCCM. We've also taken a list of all the boundaries and 
assigned them to one of 3 speed tiers for BITS throttling.

My task now is to create a collection for each of the speed tiers. Sounds like 
reusing those boundary queries (you're right, they are based on subnet IDs for 
the most part.) is the most efficient way instead of building a collection for 
every query and then rolling all the small collections up in to the larger 
collection.

From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Jason Wallace
Sent: Tuesday, March 24, 2015 10:37 AM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: RE: [mssms] RE: Which of these options would cause the least impact on 
our site server?

Also we need to consider whether you are planning to use these queries for 
anything else later.

I am guessing that since you are looking to configure BITS throttling then you 
are likely to be building something around subnet IDs?

This being the case then one option would be to create a series of collections:


-  Denver Clients - Select * from blah where IP Address LIKE 
'192.168.2%'

-  Portland Clients - Select * from bla where IP Address LIKE 
'192.16..3%'

And then make a collection


-  Clients for BITS throttling - INCLUDE Denver Clients, INCLUDE 
Portland Clients

At least this would allow you to use the Denver  Portland collections in other 
collections too

Or you could as you suggest have many queries in one collection

Or you could use a single query and the an IS IN with a list of the subnets 
that you are after

Or you could do something client side with a compliance and settings rule which 
checks for the IP subnets and then build collections for compliance  
non-compliance, targeting your revised client settings to these collections

Be warned however that if you are planning to BITS throttle AND use BranchCache 
then you may be sorely disappointed as BITS throttling affects BOTH the local 
subnet and the remote connections (other providers' solutions work differently)

HTH

From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Ed Aldrich
Sent: 24 March 2015 17:25
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: [mssms] RE: Which of these options would cause the least impact on our 
site server?

Offhand I'm thinking the latter, as the addition of 2,000 collections on top of 
what already exists may well hammer Collection Evaluator pretty hard (depending 
on the frequency of evaluation cycle). OTOH, a single query with ...a large 
amount of different queries could also hammer SQL quite hard on that 
collection's eval cycle... kind of a tough one to judge given what we know thus 
far, like how complex are the queries? How well are the queries optimized to 
minimize the SQL hit? Etc, etc...

Ed Aldrich | Channel Solutions Engineer | 1E
+1 (401) 924-2293
[Description: Description: cid:image011.png@01CAD56A.EFDE3F90] Ent Cli Mgmt 
(2003-2014)
Please consider the environment before printing this e-mail

From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Atkinson, Matt T
Sent: Tuesday, March 24, 2015 12:06 PM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: [mssms] Which of these options would cause the least impact on our 
site server?

Need to create 2 pretty large collections for targeting of client settings 
(controlling BITS throttling). Is it more efficient to create a lot 
(approximately 2000) of small collections and include them in another 
collection, or is it better to create one collection with a large number of 
different queries to determine membership? Trying to have the least amount of 
performance impact on the site server.

Matt Atkinson
Client Systems Engineer
3601 Murray Blvd Ste. 175 Beaverton, OR 97005
W: 971-282-0342 C: 503-851-4620





This message is intended for the sole use of the addressee, and may contain 
information that is privileged, confidential and exempt from disclosure under 
applicable law. If you are not the addressee you are hereby notified that you 
may not use, copy, disclose, or distribute to anyone the message or 

[mssms] RE: Help with SQL for report

[Garth Jones]

I did a quick look at one of my clean test labs and System description is 
clearly not within the Out of the Box SQL view. However it is within my main 
lab and Mike's environment. ;-)



From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Atkinson, Matt T
Sent: Tuesday, March 24, 2015 4:04 PM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: Help with SQL for report

I had a small error with the query provided by Garth, had to remove 
RV.Description0 from the select statement before it would run (doesn't exist, 
unless I'm missing something). Once I did that it ran fine.

From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones
Sent: Tuesday, March 24, 2015 12:45 PM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: [mssms] RE: Help with SQL for report

Where exactly are you seeing that... I ran this query within SSMS and it run 
without any errors, so help me understand what you are trying to do.


From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Murray, Mike
Sent: Tuesday, March 24, 2015 3:25 PM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: [mssms] RE: Help with SQL for report

Hi Garth, thank you! I'm getting this error when I save or run: An item with 
the same key has already been added

Thanks,

Mike

From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones
Sent: Tuesday, March 24, 2015 12:07 PM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: [mssms] RE: Help with SQL for report

Here is a cleanup fixed up and following best practices version of this query.

select  distinct
   RV.ResourceID,
   BIOS.SerialNumber0,
   SEU.SMBIOSAssetTag0,
   RV.Netbios_Name0,
   RV.Client_Version0,
   RV.Distinguished_Name0,
   OS.Caption0,
   OS.CSDVersion0,
   RV.Last_Logon_Timestamp0,
   WS.LastHWScan,
   CS.Manufacturer0,
   CS.Model0,
   CS.TotalPhysicalMemory0,
   OS.InstallDate0,
   OS.LastBootUpTime0,
   SCU.TopConsoleUser0,
   RV.User_Name0,RV.User_Domain0,
   BIOS.SMBIOSBIOSVersion0,
   EV.DriveLetter0,
   EV.ProtectionStatus0,
   OS.Description0,
   RV.Description0
from
   dbo.v_R_System AS RV
   LEFT OUTER JOIN dbo.v_RA_System_SystemOUName AS RASSOUN ON RV.ResourceID 
= RASSOUN.ResourceID
   LEFT OUTER JOIN dbo.v_GS_COMPUTER_SYSTEM AS CS ON CS.ResourceID = 
RV.ResourceID
   LEFT OUTER JOIN dbo.v_GS_OPERATING_SYSTEM AS OS ON OS.ResourceID = 
RV.ResourceID
   LEFT OUTER JOIN dbo.v_GS_PC_BIOS AS BIOS ON BIOS.ResourceID = 
RV.ResourceID
   LEFT OUTER JOIN dbo.v_GS_SYSTEM_CONSOLE_USAGE AS SCU ON SCU.ResourceID = 
RV.ResourceID
   LEFT OUTER JOIN dbo.v_GS_ENCRYPTABLE_VOLUME AS EV ON EV.ResourceID = 
RV.ResourceID
   LEFT OUTER JOIN dbo.v_GS_WORKSTATION_STATUS AS WS ON WS.ResourceID = 
RV.ResourceID
   left outer join dbo.v_GS_SYSTEM_ENCLOSURE_UNIQUE SEU ON RV.ResourceID = 
SEU.ResourceID
order by
   RV.Netbios_Name0





From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Atkinson, Matt T
Sent: Tuesday, March 24, 2015 2:41 PM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: [mssms] RE: Help with SQL for report

I also tried to run it in SSMS and it looks like some of the column names are 
incorrect:
SMS_R_System.operatingSystem0 should be 
SMS_R_System.Operating_System_Name_And0, etc.
[cid:image001.png@01D06632.31DD5090]

From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Murray, Mike
Sent: Tuesday, March 24, 2015 11:23 AM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: [mssms] Help with SQL for report

I'm trying to use this to create a report. When I run the report, I get:


  *   An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand)


Here's the SQL:

select  distinct 
SMS_R_System.ItemKey,SMS_G_System_PC_BIOS.SerialNumber00,v_GS_SYSTEM_ENCLOSURE_UNIQUE.AssetTag,SMS_R_System.Name0,SMS_R_System.Client_Version0,SMS_R_System.Distinguished_Name0,SMS_R_System.operatingSystem0,SMS_R_System.operatingSystemServicePac0,SMS_R_System.Last_Logon_Timestamp0,___System_WORKSTATION_STATUS3.LastHWScan,SMS_G_System_COMPUTER_SYSTEM.Manufacturer00,SMS_G_System_COMPUTER_SYSTEM.Model00,SMS_G_System_COMPUTER_SYSTEM.TotalPhysicalMemory00,SMS_G_System_OPERATING_SYSTEM.InstallDate00,SMS_G_System_OPERATING_SYSTEM.LastBootUpTime00,__ystem_SYSTEM_CONSOLE_USAGE1.TopConsoleUser00,SMS_R_System.User_Name0,SMS_R_System.User_Domain0,SMS_G_System_PC_BIOS.SMBIOSBIOSVersion00

RE: [mssms] My turn to retire

[Garth Jones]

Congrads, I wish I could do that!

From: Ken Lutzmailto:kl...@spokanecounty.org
Sent: ‎Friday‎, ‎March‎ ‎20‎, ‎2015 ‎4‎:‎01‎ ‎PM
To: SMSmailto:mssms@lists.myITforum.com

I am both pleased and saddened to announce that I will no longer be monitoring 
this list.  I must say that this has been one of the best resources for SCCM 
that one can have.  Collectively you guys are great at helping everyone!  I 
know I got a lot of direct help from the group, and learned a lot more from 
being a member of this list.

Thank-You everyone!!!

Ken Lutz
Note:  I am retiring on March 27, 2015 after 42 years of service.
Senior Systems Administrator
Information Systems Department
Spokane County
815 N. Jefferson
Spokane, Washington  99260
[cid:image001.png@01D063C3.D46CB150]

RE: [mssms] Wow ? Look how invol ved reading the Windows 10 Win d ows Update log may become

[Garth Jones]

I see you stirring the pot and raise you, sending you  some cold weather your 
way.  ☺

Honestly, time will tell, my guess is that most server desk staff will pass 
along any SU issue to the 3rd level team. Why as it would be to complex for 
them to use the KB vs CMTrace. This will increase the cost to business either 
by opening more case with MS or by have more 3rd level staff to troubleshoot 
these issues.








From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Rod Trent
Sent: Wednesday, March 4, 2015 10:39 AM
To: mssms@lists.myitforum.com
Subject: RE: [mssms] Wow ? Look how invol ved reading the Windows 10 Win d ows 
Update log may become

But, if regular updating goes away in Windows 10, why would you need to 
troubleshoot?

stirring the pot

From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones
Sent: Wednesday, March 4, 2015 10:33 AM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: RE: [mssms] Wow ? Look how invol ved reading the Windows 10 Win d ows 
Update log may become

I think that it should be added into CMtrace to read the log files!! Otherwise 
it will be impossible for anyone to troubleshoot WUA issues!



From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Rod Trent
Sent: Wednesday, March 4, 2015 10:18 AM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: RE: [mssms] Wow ? Look how invol ved reading the Windows 10 Win d ows 
Update log may become

It’s supposed to get better, but yes, it does make it more difficult.

P.S. I wrote about it here:  
http://winsupersite.com/windows-10/microsoft-makes-troubleshooting-windows-update-windows-10-tad-bit-more-difficult

From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Robert Hastings
Sent: Wednesday, March 4, 2015 10:07 AM
To: mssms@lists.myITforum.commailto:mssms@lists.myITforum.com
Subject: [mssms] Wow � Look how involved reading the Windows 10 Win dows Update 
log may become

I was forwarded this link which outlines the purposed process for reading the 
Windows Update log in Windows 10.  I can’t figure out why they want to make 
this so difficult.  This might be a good blog post on My IT Forum…  I provide 
some feedback under the “Give Feedback” section.  So much for reading logs with 
Notepad

http://support.microsoft.com/kb/3036646

RE: [mssms] Wow ? Look how invol ved reading the Windows 10 Win d ows Update log may become

[Garth Jones]

I think that it should be added into CMtrace to read the log files!! Otherwise 
it will be impossible for anyone to troubleshoot WUA issues!



From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Rod Trent
Sent: Wednesday, March 4, 2015 10:18 AM
To: mssms@lists.myitforum.com
Subject: RE: [mssms] Wow ? Look how invol ved reading the Windows 10 Win d ows 
Update log may become

It’s supposed to get better, but yes, it does make it more difficult.

P.S. I wrote about it here:  
http://winsupersite.com/windows-10/microsoft-makes-troubleshooting-windows-update-windows-10-tad-bit-more-difficult

From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Robert Hastings
Sent: Wednesday, March 4, 2015 10:07 AM
To: mssms@lists.myITforum.commailto:mssms@lists.myITforum.com
Subject: [mssms] Wow � Look how involved reading the Windows 10 Win dows Update 
log may become

I was forwarded this link which outlines the purposed process for reading the 
Windows Update log in Windows 10.  I can’t figure out why they want to make 
this so difficult.  This might be a good blog post on My IT Forum…  I provide 
some feedback under the “Give Feedback” section.  So much for reading logs with 
Notepad

http://support.microsoft.com/kb/3036646

RE: [mssms] Permissions to SSRS reports

[Garth Jones]

It will take ~ 10 minutes once the report(s) are upload to SSRS for the correct 
permission to be applied to them.  Once that is done there should be no reason 
why they don't work. If they don't make sure that you enable remote errors to 
see what is going on. 
http://www.enhansoft.com/blog/enabling-remote-errors-in-sql



-Original Message-
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Brian McDonald
Sent: Friday, February 27, 2015 10:01 AM
To: mssms@lists.myitforum.com
Subject: [mssms] Permissions to SSRS reports

Hello,

I created a custom SSRS report and can only seem to access the report when I'm 
logged into my site server. If I'm on the network using my standard account, I 
can only access canned reports. Does anyone know how to properly assigned 
permissions for SSRS reports? Assigning them through ConfigMgr doesn't do the 
trick.

Thanks!

Brian

[mssms] RE: Collection of machines online is last 1day?

[Garth Jones]

It is a report.



From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Matt Browne
Sent: Tuesday, February 17, 2015 8:14 AM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: Collection of machines online is last 1day?

Yes, thanks Mathieu.

Is that a report query or a collection query?

From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Nabil AIT HADDAD
Sent: 17 February 2015 11:54
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: [mssms] RE: Collection of machines online is last 1day?

Thanks Mathieu for your sharing !

Merci


From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of LEROY Mathieu
Sent: mardi 17 février 2015 12:14
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: [mssms] RE: Collection of machines online is last 1day?

I’m using this one to regroupe active clients

SELECT S.Name0 as 'Computer Name', S.User_Name0 as 'User Name',Case when 
CS.ClientActiveStatus='1' then 'Active' When CS.ClientActiveStatus='0' then 
'Inactive' end as 'Client Active Status' FROM v_R_System S inner Join 
v_CH_ClientSummary CS on S.ResourceId=CS.ResourceID

I guess you can tweak it a little to get what you want


Cordialement,

Mathieu Leroy
Consultant

T : +33 3 28 02 53 57 ― M : +33 6 21 63 74 15 ― F : +33 3 28 02 53 06
24 rue Papin - BP 50488 - 59664 Villeneuve d'Ascq Cedex
email : mathieu.le...@econocom-osiatis.com― web : 
www.osiatis.comhttp://www.osiatis.com/

[http://m.c.lnkd.licdn.com/media/p/5/005/03c/191/1260f51.png][Description : 
Description : Description : cid:image001.png@01CED013.AB8AF610]

De : listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] De la part de Matt Browne
Envoyé : mardi 17 février 2015 11:15
À : mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Objet : [mssms] Collection of machines online is last 1day?

Does anyone have an easy way of creating a collection of machines that have 
been online in the last 1 day?

I’m trying to use “v_CH_ClientSummary.LastOnline” but this doesn’t appear to be 
visible to collection queries.  Does anyone know another good way to do this?

Thanks

Matt Browne




Information in this message is sent in confidence and is intended only for the 
use of the individual or entity to whom it is addressed. If you are not the 
intended recipient, any use, distribution or copying of the information is 
strictly forbidden. Please notify the sender immediately by return email or 
telephone 01823 721400. If you received this email in error please delete it 
and any copies of it from your system.

Viridor Waste Management Limited
Registered Office: Peninsula House, Rydon Lane, Exeter EX2 7HR Registered in 
England No. 575069






Information in this message is sent in confidence and is intended only for the 
use of the individual or entity to whom it is addressed. If you are not the 
intended recipient, any use, distribution or copying of the information is 
strictly forbidden. Please notify the sender immediately by return email or 
telephone 01823 721400. If you received this email in error please delete it 
and any copies of it from your system.

Viridor Waste Management Limited
Registered Office: Peninsula House, Rydon Lane, Exeter EX2 7HR Registered in 
England No. 575069

RE: [mssms] SCCM 2012 R2 SiteBackup

[Garth Jones]

2am backup sounds like the normal CM12 backup the extra back is likely  from 
SQL itself. How do you know that two backup are occurring? This will help point 
to the problem.

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Joseph Rose
Sent: Tuesday, February 17, 2015 8:43 AM
To: mssms@lists.myITforum.com
Subject: [mssms] SCCM 2012 R2 SiteBackup

I am seeing an odd behavior where my site server is taking 2 backups daily? I 
have specified 1 backup to run at 2 am and that time is consistent. The other 
backup seems to move around in time. I have reviewed the smswriter.log and it 
references OnIdentify event triggered. which is the same event as the scheduled 
backup. Does anyone know where I can dig deeper? I am going to start looking in 
the DB for the settings. If you know where its located that would be great.



https://www.mcpvirtualbusinesscard.com/VBCServer/jrose/profile

RE: [mssms] query Add Remove Programs (32 and 64)

[Garth Jones]

What exactly does your query look like? How exact did you write you joins?


From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of sms sccm
Sent: Wednesday, February 11, 2015 12:33 PM
To: mssms@lists.myitforum.com
Subject: [mssms] query Add Remove Programs (32 and 64)

Dear all,

I need a query for systems (x32 and x64) not having .NET 4.5.2


first I did a query that should give me all .NET 4.5.2 installations:


[cid:image001.jpg@01D045F9.A2507720]

but it only returns records for x64 OS


I know there are records for x32:

[cid:image002.jpg@01D045F9.A2507720]

this returns x32 Systems

why does the first query not work for Installed Applications (64).Display 
Name OR Installed Applications.Display Name???

The built-in report Computers with specific software registered in Add Remove 
Programs does return all records because it is using the view 
v_Add_Remove_Programs.

I need the same data with a query to create a collection.


Thanks for any insights

RE: [mssms] query Add Remove Programs (32 and 64)

[Garth Jones]

You problem is that you have an inner join between the x86 and x64 view. 
Therefore you will only see data from the x64 computers. Instead use an outer 
join to get either x86 or x64.

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of sms sccm
Sent: Wednesday, February 11, 2015 1:03 PM
To: mssms@lists.myitforum.com
Subject: RE: [mssms] query Add Remove Programs (32 and 64)



[cid:image003.jpg@01D0460B.FF803040]




From: ga...@enhansoft.commailto:ga...@enhansoft.com
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: RE: [mssms] query Add Remove Programs (32 and 64)
Date: Wed, 11 Feb 2015 17:57:13 +
What exactly does your query look like? How exact did you write you joins?


From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of sms sccm
Sent: Wednesday, February 11, 2015 12:33 PM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: [mssms] query Add Remove Programs (32 and 64)

Dear all,

I need a query for systems (x32 and x64) not having .NET 4.5.2


first I did a query that should give me all .NET 4.5.2 installations:


[cid:image004.jpg@01D0460B.FF803040]

but it only returns records for x64 OS


I know there are records for x32:

[cid:image005.jpg@01D0460B.FF803040]

this returns x32 Systems

why does the first query not work for Installed Applications (64).Display 
Name OR Installed Applications.Display Name???

The built-in report Computers with specific software registered in Add Remove 
Programs does return all records because it is using the view 
v_Add_Remove_Programs.

I need the same data with a query to create a collection.


Thanks for any insights

[mssms] RE: Changing SCCM port

[Garth Jones]

Err I would stay way from moving ports but Why can't you Network team do 
QOS for BITS traffic? Their packetshaper should be able to do this without any 
problem.


From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Atkinson, Matt T
Sent: Thursday, January 8, 2015 6:24 PM
To: mssms@lists.myitforum.com
Subject: [mssms] Changing SCCM port

Hi All,

We've been asked to look in to what it would take to modify the current 
communication port used by our SCCM 2012 environment. Although I can see how to 
configure it from the beginning of a deployment, and where it can be changed, 
details online are sparse when it comes to changing the ports for an existing 
environment. My fear is that changing the communication port would leave our 
existing clients unmanaged and require us to redeploy the client.

Anyone have any experience in doing this? The end goal is for our network team 
to be able to apply QOS policies for SCCM based simply on the port the traffic 
is happening on. The major concern being content downloads from clients to DPs. 
The options for BITS throttling leave a lot to be desired, hence the request 
for QOS policies to be used instead.

Thanks!
Matt



This message is intended for the sole use of the addressee, and may contain 
information that is privileged, confidential and exempt from disclosure under 
applicable law. If you are not the addressee you are hereby notified that you 
may not use, copy, disclose, or distribute to anyone the message or any 
information contained in the message. If you have received this message in 
error, please immediately advise the sender by reply email and delete this 
message.

RE: [mssms] SCCM 2012 reports not running for standard user

[Garth Jones]

So I'm just getting back to this now both Jeff and Greg have helped flush this 
out. You need to make sure that the users accessing the SSRS site are assigned 
to the Reporting Role that you created and that you assign them access to the 
collections they need access too.

This blog/video might help out.
http://be.enhansoft.com/post/2013/10/21/Role-Based-Administration-(RBA)-Reporting-Feature-in-SCCM-2012-R2.aspx




From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of pd...@nlh.nl.ca
Sent: Tuesday, January 6, 2015 6:50 AM
To: mssms@lists.myitforum.com
Subject: RE: [mssms] SCCM 2012 reports not running for standard user

Garth,  thanks for the response.

Hopefully this is what your this is what you are talking about

Within the properties for the Reporting Services Point role, I have a user name 
set.  It is an Active Directory account.

When I check the rights for that account against the ReportServer database, it 
has db_owner, public and RSExecRole role membership.  Against the CM database, 
the account has public and smsschm_users role membership.  Against the Master 
database it has Public and RSExecRole role membership.  Against the 
ReportServerTempDB database it has db_owner, public and RSExecRole role 
membership.

It this what you were referring too?

Paul


From:Garth Jones ga...@enhansoft.commailto:ga...@enhansoft.com
To:mssms@lists.myitforum.commailto:mssms@lists.myitforum.com 
mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Date:01/05/2015 05:58 PM
Subject:RE: [mssms] SCCM 2012 reports not running for standard user
Sent by:
listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com




If you are not seeing any data it is most likely because of how RBA is setup. 
How exactly did you setup the reporting role?


From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of 
pd...@nlh.nl.camailto:pd...@nlh.nl.ca
Sent: Monday, January 5, 2015 12:05 PM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: [mssms] SCCM 2012 reports not running for standard user

Hi,

I am having an issue running reports from the SQL Server Reporting Services 
URL.  I have two accounts,  an elevated account the is part of Domain Admins 
and has the Full Administrator security role within SCCM 2012 and a standard 
user account that has no domain privileges.  My standard account though is part 
of an AD group for SCCM reporting that I am trying to grant privileges to run 
reports.

If I start IE with my standard account, none of the drop downs (for Collection 
, etc) populate.  Thought if the report has no drop downs iI will get the 
report headign information but no data.

If I start IE with my elevated account I can run reports fine.

Based on Google searches, I have added the following security to the Report 
Viewers Security role:
 1. set Read permissions to Yes for Site
 2. set View Asset Intelligence to Yes for Software Titles
 Note: this did not fix the issue

I have granted the AD group datareader permissions on the SCCM SQL Server and 
REportign server databases...this did not work.  Just to check, I granted the 
group SysAdmin privileges to the databases..did not work either and have 
since removed.

Anyone have any idea what set of permissions I am missing?

Thanks and Happy New Year,
Paul

RE: [mssms] Summarization - Collection in console

[Garth Jones]

Err ok but you do know that the console has more overhead to it than running 
reports.  Plus you now have to give each user the console and therefore anytime 
you install a CU or R or SP release you will need to update every user.

The summarizing task are not documents anywhere (to my knowledge). Since I 
always want my users to see the most current data, I never point them to the 
console and only point them to the reports, plus I'm still a firm believe that 
you need to keep everyone out of the console (even with RBA enabled)




From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of sccmfun
Sent: Wednesday, December 31, 2014 1:47 PM
To: mssms@lists.myitforum.com
Subject: RE: [mssms] Summarization - Collection in console

We have some users who don't have access to the reports, rbac'ed them so all 
they have is console access.  Chances are I'm going to leave it the way it is, 
but for my own knowledge would of liked to know how to kick it off and not wait 
to summarize.

From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones
Sent: Wednesday, December 31, 2014 11:41 AM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: RE: [mssms] Summarization - Collection in console

I'm unclear as to why you wouldn't use reports. Report will ALWAYS be 100% 
update date, the console will be up to 24 hours out of date as the data is 
summarized, in order to allow the console to be  fast.

IMO you should NEVER use the console for anything except for creating 
collection and deploying software. It is just not as efficient as the reports.



From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Roland Janus
Sent: Wednesday, December 31, 2014 10:37 AM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: RE: [mssms] Summarization - Collection in console

Because it's not the same thing and having data in that view but not being 
accurate would make it useless.

I have the same question with clients showing 29.12. as scan date, but there is 
inventory from today (31th), hence the question, where is that data coming from 
and what would update it?

-R


From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones
Sent: Mittwoch, 31. Dezember 2014 15:51
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: RE: [mssms] Summarization - Collection in console

Why wouldn't you use a report for this? What exactly are you trying to do?

From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of sccmfun
Sent: Wednesday, December 31, 2014 9:17 AM
To: mssms@lists.myITforum.commailto:mssms@lists.myITforum.com
Subject: [mssms] Summarization - Collection in console

Does anyone know how to force summarization so you can see up-to-date info such 
as HW inventory scan when looking at machines in a collection.

If you look at a collection of machines and select the different columns, one 
of them being hardware inventory, the data is outdated.  I know this view is 
based off summarization, but don't know what the summarization schedule is or 
how to kick it off manually.  I searched for the stored proc, but no luck.  I'm 
also confused as the summarization for the policy requests column seems to 
update more frequently, but doesn't look like the hardware or other info is 
updated as quick.  I would assume it's one stored proc that updates everything, 
but then wouldn't all columns update and not just the policy request?

Any info on this is appreciated.

Happy New Year!

RE: [mssms] Summarization - Collection in console

[Garth Jones]

If I'm already in the console and I don't need 100% update data then the 
console is fine.
But if I'm not in the console or that I need 100% up to date data them the 
reports will be faster/better.

Doing it more often will clearly impact performance. The real issue is do you 
care? IMO for 2000 computer if you see any performance issues running the 
summarizer more than once every 24 hours then you have much bigger problems.

Just my two Canadian cents. :)



From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Roland Janus
Sent: Wednesday, December 31, 2014 7:26 PM
To: mssms@lists.myitforum.com
Subject: RE: [mssms] Summarization - Collection in console

I'm not saying I wouldn't use the reports, but it is easier and faster to see 
some basic information while I'm already in the console and the collection 
instead of opening a report.
If I know it's a day behind, everything below may worth a look into.

The same record now updated after 2 days. That probably could be speed up. We 
may only have max 2000 clients, doing anything more often shouldn't impact 
performance but make that actually useful.

-R

From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones
Sent: Mittwoch, 31. Dezember 2014 17:41
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: RE: [mssms] Summarization - Collection in console

I'm unclear as to why you wouldn't use reports. Report will ALWAYS be 100% 
update date, the console will be up to 24 hours out of date as the data is 
summarized, in order to allow the console to be  fast.

IMO you should NEVER use the console for anything except for creating 
collection and deploying software. It is just not as efficient as the reports.



From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Roland Janus
Sent: Wednesday, December 31, 2014 10:37 AM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: RE: [mssms] Summarization - Collection in console

Because it's not the same thing and having data in that view but not being 
accurate would make it useless.

I have the same question with clients showing 29.12. as scan date, but there is 
inventory from today (31th), hence the question, where is that data coming from 
and what would update it?

-R


From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones
Sent: Mittwoch, 31. Dezember 2014 15:51
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: RE: [mssms] Summarization - Collection in console

Why wouldn't you use a report for this? What exactly are you trying to do?

From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of sccmfun
Sent: Wednesday, December 31, 2014 9:17 AM
To: mssms@lists.myITforum.commailto:mssms@lists.myITforum.com
Subject: [mssms] Summarization - Collection in console

Does anyone know how to force summarization so you can see up-to-date info such 
as HW inventory scan when looking at machines in a collection.

If you look at a collection of machines and select the different columns, one 
of them being hardware inventory, the data is outdated.  I know this view is 
based off summarization, but don't know what the summarization schedule is or 
how to kick it off manually.  I searched for the stored proc, but no luck.  I'm 
also confused as the summarization for the policy requests column seems to 
update more frequently, but doesn't look like the hardware or other info is 
updated as quick.  I would assume it's one stored proc that updates everything, 
but then wouldn't all columns update and not just the policy request?

Any info on this is appreciated.

Happy New Year!

RE: [mssms] Summarization - Collection in console

[Garth Jones]

How often are you doing HW Inv? How often are you doing Heartbeat discovery?

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Lindenfeld, Ivan
Sent: Monday, January 5, 2015 4:40 PM
To: mssms@lists.myitforum.com
Subject: RE: [mssms] Summarization - Collection in console

Hi folks,

I did a deep dive into the frequency of update of HINV in the collection 
columns recently.  While I never proved a refresh for the summarization, it was 
long enough that it made using those HINV dates not useful within about a week.

I did discover that the Policy Request column is realtime.  I tried to create a 
collection query that would show me Policy Request dates within x days so I 
could base actions such as software update only on super fresh clients.  
However, I have not yet found how to expose the Policy Request date in the 
collection column based on the WMI classes that are available in a collection 
query.

Ivan Lindenfeld

From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones
Sent: Monday, January 5, 2015 4:32 PM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: RE: [mssms] Summarization - Collection in console

Err ok but you do know that the console has more overhead to it than running 
reports.  Plus you now have to give each user the console and therefore anytime 
you install a CU or R or SP release you will need to update every user.

The summarizing task are not documents anywhere (to my knowledge). Since I 
always want my users to see the most current data, I never point them to the 
console and only point them to the reports, plus I'm still a firm believe that 
you need to keep everyone out of the console (even with RBA enabled)




From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of sccmfun
Sent: Wednesday, December 31, 2014 1:47 PM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: RE: [mssms] Summarization - Collection in console

We have some users who don't have access to the reports, rbac'ed them so all 
they have is console access.  Chances are I'm going to leave it the way it is, 
but for my own knowledge would of liked to know how to kick it off and not wait 
to summarize.

From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones
Sent: Wednesday, December 31, 2014 11:41 AM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: RE: [mssms] Summarization - Collection in console

I'm unclear as to why you wouldn't use reports. Report will ALWAYS be 100% 
update date, the console will be up to 24 hours out of date as the data is 
summarized, in order to allow the console to be  fast.

IMO you should NEVER use the console for anything except for creating 
collection and deploying software. It is just not as efficient as the reports.



From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Roland Janus
Sent: Wednesday, December 31, 2014 10:37 AM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: RE: [mssms] Summarization - Collection in console

Because it's not the same thing and having data in that view but not being 
accurate would make it useless.

I have the same question with clients showing 29.12. as scan date, but there is 
inventory from today (31th), hence the question, where is that data coming from 
and what would update it?

-R


From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones
Sent: Mittwoch, 31. Dezember 2014 15:51
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: RE: [mssms] Summarization - Collection in console

Why wouldn't you use a report for this? What exactly are you trying to do?

From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of sccmfun
Sent: Wednesday, December 31, 2014 9:17 AM
To: mssms@lists.myITforum.commailto:mssms@lists.myITforum.com
Subject: [mssms] Summarization - Collection in console

Does anyone know how to force summarization so you can see up-to-date info such 
as HW inventory scan when looking at machines in a collection.

If you look at a collection of machines and select the different columns, one 
of them being hardware inventory, the data is outdated.  I know this view is 
based off summarization, but don't know what the summarization schedule is or 
how to kick it off manually.  I searched for the stored proc, but no luck.  I'm 
also confused as the summarization for the policy requests column seems to 
update more frequently, but doesn't look like the hardware or other info is 
updated as quick.  I would assume it's one stored proc

RE: [mssms] SCCM 2012 reports not running for standard user

[Garth Jones]

If you are not seeing any data it is most likely because of how RBA is setup. 
How exactly did you setup the reporting role?


From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of pd...@nlh.nl.ca
Sent: Monday, January 5, 2015 12:05 PM
To: mssms@lists.myitforum.com
Subject: [mssms] SCCM 2012 reports not running for standard user

Hi,

I am having an issue running reports from the SQL Server Reporting Services 
URL.  I have two accounts,  an elevated account the is part of Domain Admins 
and has the Full Administrator security role within SCCM 2012 and a standard 
user account that has no domain privileges.  My standard account though is part 
of an AD group for SCCM reporting that I am trying to grant privileges to run 
reports.

If I start IE with my standard account, none of the drop downs (for Collection 
, etc) populate.  Thought if the report has no drop downs iI will get the 
report headign information but no data.

If I start IE with my elevated account I can run reports fine.

Based on Google searches, I have added the following security to the Report 
Viewers Security role:
  1. set Read permissions to Yes for Site
  2. set View Asset Intelligence to Yes for Software Titles
  Note: this did not fix the issue

I have granted the AD group datareader permissions on the SCCM SQL Server and 
REportign server databases...this did not work.  Just to check, I granted the 
group SysAdmin privileges to the databases..did not work either and have 
since removed.

Anyone have any idea what set of permissions I am missing?

Thanks and Happy New Year,
Paul

RE: [mssms] Summarization - Collection in console

[Garth Jones]

Why wouldn't you use a report for this? What exactly are you trying to do?

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of sccmfun
Sent: Wednesday, December 31, 2014 9:17 AM
To: mssms@lists.myITforum.com
Subject: [mssms] Summarization - Collection in console

Does anyone know how to force summarization so you can see up-to-date info such 
as HW inventory scan when looking at machines in a collection.

If you look at a collection of machines and select the different columns, one 
of them being hardware inventory, the data is outdated.  I know this view is 
based off summarization, but don't know what the summarization schedule is or 
how to kick it off manually.  I searched for the stored proc, but no luck.  I'm 
also confused as the summarization for the policy requests column seems to 
update more frequently, but doesn't look like the hardware or other info is 
updated as quick.  I would assume it's one stored proc that updates everything, 
but then wouldn't all columns update and not just the policy request?

Any info on this is appreciated.

Happy New Year!

[mssms] RE: CCMEXEC is taking up over 3gb of RAM

[Garth Jones]

34mb, and I have a ton of extra inventory classes!

I don't manage it at all. :)


From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Jeff Gortney
Sent: December 5, 2014 9:34 AM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: CCMEXEC is taking up over 3gb of RAM

OK here is what I found out.  CCMEXEC was reading the InventoryStore.SDF file 
which grew to over 4gb in size.  This has to be tied to hardware inventory 
somehow.  On a hunch, I renamed that file and rebooted the laptop. And CCMEXEC 
barely touched memory.

It seems like this performance issue is tied to the size of this file, and the 
fact that the majority of my laptops in the field have only 4gb of ram on them. 
 So when CCMEXEC tries to read a 4 GB file it starts using swap space and slows 
the system down.

How big is everyone's InventoryStore.sdf and how to you manage the size of that 
file?

[https://portal.fivesgroup.com/FIRSTspiritWeb/fivesportal/media/images_for_content/fives_1/signatures/logo_tagline.png]



Jeff  GORTNEY

Systems and Network Support Specialist

- Combustion

Fives North American Combustion Inc.

4455 East 71st Street

Cleveland,  Ohio,  44105-5600 - United States

Tel: +1 216 206 5508

Fax: +1 216 641 7852


jeff.gort...@fivesgroup.commailto:jeff.gort...@fivesgroup.com

www.fivesgroup.comhttp://www.fivesgroup.com/

[https://portal.fivesgroup.com/FIRSTspiritWeb/fivesportal/media/images_for_content/fives_1/signatures/signature_facebook.png]https://www.facebook.com/pages/Fives/278132595611080[https://portal.fivesgroup.com/FIRSTspiritWeb/fivesportal/media/images_for_content/fives_1/signatures/signature_linkedin.png]http://www.linkedin.com/company/fives?trk=top_nav_home




This message and any attachments are confidential and for the sole attention of 
the addressees. Any unauthorized use or dissemination is prohibited.
Ce message et toutes pièces jointes sont confidentiels et à l'attention 
exclusive de ses destinataires.Toute utilisation ou diffusion non autorisée est 
interdite.
Please think about the environment before printing this e-mail. // Merci de 
penser à l'environnement avant d'imprimer cet e-mail.



From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Gilmanov, Nile
Sent: Thursday, December 04, 2014 10:45 AM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: [mssms] RE: CCMEXEC is taking up over 3gb of RAM

You could also monitor it if you have SCOM... or even perhaps PerfMon.msc and 
monitor that service after you have taken steps to resolve.

Monitoring will give you a timeline of when things go crazy.

Nile Gilmanov
Systems Administrator
Wabash National Corporation
nile.gilma...@wabashnational.commailto:nile.gilma...@wabashnational.com | 
Office: 765.772.2691 | Mobile: 765.414.7402

From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Heaton, Joseph@Wildlife
Sent: Thursday, December 4, 2014 10:37 AM
To: 'mssms@lists.myitforum.com'
Subject: [mssms] RE: CCMEXEC is taking up over 3gb of RAM

Wow, that's huge.  My ccmexec is humming along at 30MB.  I'd cycle the SMS 
Agent Host service, maybe something got stuck.

From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Jeff Gortney
Sent: Thursday, December 04, 2014 6:52 AM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: [mssms] CCMEXEC is taking up over 3gb of RAM

I have a user who is complaining of a slow PC.  I have run procmon on the PC 
and noticed that CCMEXEC is taking up over 3gb of ram on the PC.  What logs 
would be best to start looking though to find out why this is happening?

Thanks for the help!

[https://portal.fivesgroup.com/FIRSTspiritWeb/fivesportal/media/images_for_content/fives_1/signatures/logo_tagline.png]



Jeff  GORTNEY

Systems and Network Support Specialist

- Combustion

Fives North American Combustion Inc.

4455 East 71st Street

Cleveland,  Ohio,  44105-5600 - United States

Tel: +1 216 206 5508

Fax: +1 216 641 7852


jeff.gort...@fivesgroup.commailto:jeff.gort...@fivesgroup.com

www.fivesgroup.comhttp://www.fivesgroup.com/

[https://portal.fivesgroup.com/FIRSTspiritWeb/fivesportal/media/images_for_content/fives_1/signatures/signature_facebook.png]https://www.facebook.com/pages/Fives/278132595611080[https://portal.fivesgroup.com/FIRSTspiritWeb/fivesportal/media/images_for_content/fives_1/signatures/signature_linkedin.png]http://www.linkedin.com/company/fives?trk=top_nav_home




This message and any attachments are confidential and for the sole attention of 
the addressees. Any unauthorized use or dissemination is prohibited.
Ce message et toutes pièces jointes sont confidentiels et à l'attention 
exclusive de ses destinataires.Toute utilisation ou diffusion non autorisée est 
interdite.
Please think about the environment 

RE: [mssms] RE: CCMEXEC is taking up over 3gb of RAM

[Garth Jones]

It take 4 hours on my laptop with an SSD drive!
http://be.enhansoft.com/post/2013/10/03/Slow-Software-Inventory-Cycle-in-SCCM-2012.aspx


From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Greg Thomas
Sent: December 5, 2014 12:27 PM
To: mssms@lists.myitforum.com
Subject: RE: [mssms] RE: CCMEXEC is taking up over 3gb of RAM

Its very, very rare that I find a customer with an actual need for Software 
Inventory.  Like Nash said, many folks assume information on installed software 
comes from Software Inventory, which it does not.  And yes, it burns a bunch of 
resources when it runs if you are inventorying a large number of file names, 
types, and especially locations (i.e. not limiting the location to a specific 
directory).

If you want to do a quick test of this, add a few file types to your software 
inventory, update your policy on a client, and run the sinv from the control 
panel applet.  Monitor the inventory.log to see how long it takes to complete 
(feel free to add perfmon's for memory/cpu/io/etc if you really want to spend 
the time).  This will be a matter of many minutes and sometimes hours, 
depending on the size of the disk you are scouring.  Just please make sure you 
don't accidentally check the box to collect the files as well.

Then run a full hardware inventory and monitor the same log to see how long it 
takes to complete. This will probably be a matter of 10-90 seconds.

From: na...@nowmicro.commailto:na...@nowmicro.com
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: [mssms] RE: CCMEXEC is taking up over 3gb of RAM
Date: Fri, 5 Dec 2014 17:03:33 +
The feature is not really broken, it is just misnamed so people end up using it 
poorly.  It should be called File Inventory instead of Software Inventory.

The push to get people to stop using it stems from the fact that customers 
enable it thinking they are grabbing Add/Remove Programs info, when in fact 
they are just storing a crap load of file metadata that may or may not actually 
be directly related to what is 'installed' on a computer.

My fingers are crossed that in vNext they'll make some feature renames to fix 
the confusion:

Hardware Inventory = System Inventory
Software Inventory = File Inventory




From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Miller, Todd
Sent: Friday, December 5, 2014 10:47 AM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: [mssms] RE: CCMEXEC is taking up over 3gb of RAM

How about we rally to get Microsoft to fix software inventory instead of 
begging everyone to stop using it?  Their AV software is touching every file as 
it is read in and doing full scans periodically successfully, right?  The index 
service is crawling the hard drive and maintaining a DB of file contents.  Why 
does the SCCM team have such a hard time figuring out how to inventory 
software, and why are we all letting them off the hook?

Getting everyone to stop using it is not exactly a great solution to the 
problem.   Instead, we should be demanding a product that works well.

From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Daniel Ratliff
Sent: Friday, December 05, 2014 9:58 AM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: [mssms] RE: CCMEXEC is taking up over 3gb of RAM

Use Compliance if you do, not SINV!

http://myitforum.com/myitforumwp/2014/11/14/using-configuration-items-instead-of-software-inventory/

Daniel Ratliff

From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Gilmanov, Nile
Sent: Friday, December 05, 2014 10:40 AM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: [mssms] RE: CCMEXEC is taking up over 3gb of RAM

I guess one more thing to inventory (file size of the latter file).

Nile Gilmanov
Systems Administrator
Wabash National Corporation
nile.gilma...@wabashnational.commailto:nile.gilma...@wabashnational.com | 
Office: 765.772.2691 | Mobile: 765.414.7402

From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Daniel Ratliff
Sent: Friday, December 5, 2014 10:34 AM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: [mssms] RE: CCMEXEC is taking up over 3gb of RAM

We have a pretty good size inventory, and my machine has a 133MB file.

Daniel Ratliff

From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Heaton, Joseph@Wildlife
Sent: Friday, December 05, 2014 10:26 AM
To: 'mssms@lists.myitforum.com'
Subject: [mssms] RE: CCMEXEC is taking up over 3gb of RAM

38MB here, and I've never thought about that file until you mentioned it.

From: 

RE: [mssms] RE: CCMEXEC is taking up over 3gb of RAM

[Garth Jones]

Try this instead, it use almost no resources.
http://mnscug.org/blogs/sherry-kissinger




From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Miller, Todd
Sent: December 5, 2014 1:30 PM
To: mssms@lists.myitforum.com
Subject: RE: [mssms] RE: CCMEXEC is taking up over 3gb of RAM

We use it all the time.  What machines have Chrome or Dropbox installed?  
Applications installed by the user don't show in add remove programs since 
the normal user just has it in his/her own user profile.   There are gobs of 
applications running on systems that are not part of any installed package.  If 
you don't have software inventory  turned it on, you don't know what you don't 
know.  My security office asked me a couple of days ago if we had any computers 
with igfxtrayex.exe installed.  Unsure where on the drive it would be.

Taking a really long time to run wouldn't be a big deal if it didn't block any 
other SCCM actions. If the software inventory process  was non-blocking, I 
couldn't care less how long it takes to run.  Oh, it also should be resilient 
to power down and sleep if it is going to take hours to run.  Who leaves their 
computer awake long enough to complete a SWINV?
From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Greg Thomas
Sent: Friday, December 05, 2014 11:27 AM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: RE: [mssms] RE: CCMEXEC is taking up over 3gb of RAM

Its very, very rare that I find a customer with an actual need for Software 
Inventory.  Like Nash said, many folks assume information on installed software 
comes from Software Inventory, which it does not.  And yes, it burns a bunch of 
resources when it runs if you are inventorying a large number of file names, 
types, and especially locations (i.e. not limiting the location to a specific 
directory).

If you want to do a quick test of this, add a few file types to your software 
inventory, update your policy on a client, and run the sinv from the control 
panel applet.  Monitor the inventory.log to see how long it takes to complete 
(feel free to add perfmon's for memory/cpu/io/etc if you really want to spend 
the time).  This will be a matter of many minutes and sometimes hours, 
depending on the size of the disk you are scouring.  Just please make sure you 
don't accidentally check the box to collect the files as well.

Then run a full hardware inventory and monitor the same log to see how long it 
takes to complete. This will probably be a matter of 10-90 seconds.

From: na...@nowmicro.commailto:na...@nowmicro.com
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: [mssms] RE: CCMEXEC is taking up over 3gb of RAM
Date: Fri, 5 Dec 2014 17:03:33 +
The feature is not really broken, it is just misnamed so people end up using it 
poorly.  It should be called File Inventory instead of Software Inventory.

The push to get people to stop using it stems from the fact that customers 
enable it thinking they are grabbing Add/Remove Programs info, when in fact 
they are just storing a crap load of file metadata that may or may not actually 
be directly related to what is 'installed' on a computer.

My fingers are crossed that in vNext they'll make some feature renames to fix 
the confusion:

Hardware Inventory = System Inventory
Software Inventory = File Inventory




From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Miller, Todd
Sent: Friday, December 5, 2014 10:47 AM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: [mssms] RE: CCMEXEC is taking up over 3gb of RAM

How about we rally to get Microsoft to fix software inventory instead of 
begging everyone to stop using it?  Their AV software is touching every file as 
it is read in and doing full scans periodically successfully, right?  The index 
service is crawling the hard drive and maintaining a DB of file contents.  Why 
does the SCCM team have such a hard time figuring out how to inventory 
software, and why are we all letting them off the hook?

Getting everyone to stop using it is not exactly a great solution to the 
problem.   Instead, we should be demanding a product that works well.

From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Daniel Ratliff
Sent: Friday, December 05, 2014 9:58 AM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: [mssms] RE: CCMEXEC is taking up over 3gb of RAM

Use Compliance if you do, not SINV!

http://myitforum.com/myitforumwp/2014/11/14/using-configuration-items-instead-of-software-inventory/

Daniel Ratliff

From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Gilmanov, Nile
Sent: Friday, December 

RE: [mssms] OT: New RDCMan! Finally!

[Garth Jones]

That was there in the old version  RDCM too. You could do it on a computer, a 
group or the whole RDCM. I don’t use it but it is there. ☺

[cid:image001.png@01D00683.238D0030]

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Paul Winstanley
Sent: Wednesday, November 19, 2014 9:02 AM
To: mssms@lists.myitforum.com
Subject: Re: [mssms] OT: New RDCMan! Finally!

Daniel,

Personally I prefer http://www.mremoteng.org/. You can apply credentials to 
folders and drag and drop computers around to pick up the new settings. Haven't 
used RDCMan in years so not sure if this functionality is included in it.

On Wed, Nov 19, 2014 at 1:57 PM, Daniel Ratliff 
dratl...@humana.commailto:dratl...@humana.com wrote:
I use this every day, great free tool for Remote Desktop. They finally released 
an updated version 2.7!

http://www.microsoft.com/en-us/download/details.aspx?id=44989

Daniel Ratliff


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.

RE: [mssms] Hardware Inventory Issues

[Garth Jones]

Don't forget about the right-click tools to they can force full inventory on a 
whole collection.



From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of John Aubrey
Sent: Thursday, November 6, 2014 1:53 PM
To: 'mssms@lists.myitforum.com'
Subject: RE: [mssms] Hardware Inventory Issues

I haven't found a way to mass blow out a full inventory scan.  Not sure of how 
that would affect the server, probably won't make it happy to say the least.

From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Jeff Poling
Sent: Thursday, November 6, 2014 4:20 PM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: RE: [mssms] Hardware Inventory Issues

I tried a full hardware inventory on a few machines and that seems to have 
worked.  Thanks for the idea!

I've been at this site for a few days and performed the upgrades to SP1 and R2, 
so maybe I am just not being patient enough to allow this to resolve on its 
own. . .  :)

Thanks,

Jeff


From: jaub...@norwoodmedical.commailto:jaub...@norwoodmedical.com
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: RE: [mssms] Hardware Inventory Issues
Date: Thu, 6 Nov 2014 20:56:39 +
Did you try to do a full hardware inventory on a few machines?  I have had some 
issues with bad mifs and running a full scan fixes it. I always let this kind 
of issue sit a couple days and it works itself out.

From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Jeff Poling
Sent: Thursday, November 6, 2014 3:52 PM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: [mssms] Hardware Inventory Issues

I am having an issue with hardware inventory in ConfigMgr 2012 at a customer.  
Numerous machines are not getting good HW inventory and have MIF files that get 
placed in the BADMIFS directories.  The site was recently upgraded to SP1 and 
from there to R2 CU3.  The ivnentory issue existed prior to the SP1 to R2 
upgrade.

I see numerous dataldr warnings and errors:

Inventory Data Loader failed to process the delta MIF file XHLI3TFB3.MIF and 
has moved it to D:\Program Files\Microsoft Configuration 
Manager\inboxes\auth\dataldr.box\BADMIFS\Outdated\dru1e5aq.MIF.
Possible cause: The file attempted to update inventory information in the site 
database that does not already exist, or the file contains invalid syntax.

Inventory Data Loader failed to process the file D:\Program Files\Microsoft 
Configuration Manager\inboxes\auth\dataldr.box\Process\HRHNGT8D.MIF because it 
is larger than the defined maximum allowable size of 500.

I know I can increase the maximum allowed size of the MIFs, but I do not 
understand why they are so large.  THe customer did have the AI class for 
InstalledExecutable enabled, but we turned that off since no one knew why it 
was enabled.

Also, as a possible side effect of this, the data in the SMS_G_System_SYSTEM 
class does not seem to be correct.

Is there a good way to determine the root cause of the various HW inventory 
failures?

Thanks,

Jeff

[mssms] RE: Need help with the case statement in a report query

[Garth Jones]

I know for sure that it have been part of default values within SMS 2.0 and 
above. And I'm willing to bet it was there in SMS 1.0 too.
Check out v_gs_system.systemrole0


From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Marcum, John
Sent: Friday, October 31, 2014 2:15 PM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: Need help with the case statement in a report query

If you are using BDNA this is in the view by default for you. :-)

[cid:image001.png@01CFF51A.9AE61B00]

From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Linkey, Mike
Sent: Friday, October 31, 2014 1:03 PM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: [mssms] RE: Need help with the case statement in a report query

I don't have all of your values, but try this.  I only put in XP and Windows 7, 
but you get the idea.

SELECTSMS_R_System.ItemKey, SMS_R_System.Netbios_Name0, 
SMS_R_System.Operating_System_Name_and0, SMS_R_System.Full_Domain_Name0,
 SMS_G_System_CH_ClientSummary.LastPolicyRequest AS 
'Last Policy Check',
 CASE (dbo.v_GS_OPERATING_SYSTEM.Caption0)
 WHEN 'Microsoft Windows XP Professional' THEN 
'Workstation'
 WHEN 'Microsoft Windows 7 Enterprise' THEN 
'Workstation'
 ELSE 'Server'
 END as 'role'
FROMdbo.vSMS_R_System AS SMS_R_System INNER JOIN
 dbo.v_CH_ClientSummary AS 
SMS_G_System_CH_ClientSummary ON SMS_G_System_CH_ClientSummary.ResourceID = 
SMS_R_System.ItemKey INNER JOIN
dbo.v_GS_OPERATING_SYSTEM ON 
SMS_G_System_CH_ClientSummary.ResourceID = dbo.v_GS_OPERATING_SYSTEM.ResourceID
where SMS_R_System.Full_Domain_Name0 LIKE @domain AND
dbo.v_GS_OPERATING_SYSTEM.Caption0 LIKE @OS
AND SMS_R_System.Netbios_Name0 LIKE @hostname AND 
SMS_R_System.Operating_System_Name_and0 LIKE @ServerWorkstations


From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Atkinson, Matt
Sent: Friday, October 31, 2014 12:53 PM
To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com
Subject: [mssms] Need help with the case statement in a report query

Hi All,

I've built this report query, but I think I need to use a CASE statement to 
change the displayed value in the last column to just read server or 
workstation based on the OS. Everything I've tried so far has just given me a 
syntax error.

SELECTSMS_R_System.ItemKey, SMS_R_System.Netbios_Name0, 
SMS_R_System.Operating_System_Name_and0, SMS_R_System.Full_Domain_Name0,
 SMS_G_System_CH_ClientSummary.LastPolicyRequest AS 
'Last Policy Check', dbo.v_GS_OPERATING_SYSTEM.Caption0
FROMdbo.vSMS_R_System AS SMS_R_System INNER JOIN
 dbo.v_CH_ClientSummary AS 
SMS_G_System_CH_ClientSummary ON SMS_G_System_CH_ClientSummary.ResourceID = 
SMS_R_System.ItemKey INNER JOIN
dbo.v_GS_OPERATING_SYSTEM ON 
SMS_G_System_CH_ClientSummary.ResourceID = dbo.v_GS_OPERATING_SYSTEM.ResourceID
where SMS_R_System.Full_Domain_Name0 LIKE @domain AND
dbo.v_GS_OPERATING_SYSTEM.Caption0 LIKE @OS
AND SMS_R_System.Netbios_Name0 LIKE @hostname AND 
SMS_R_System.Operating_System_Name_and0 LIKE @ServerWorkstations

Any suggestions how to structure the query?

Matt Atkinson
Client Systems Engineer





This message is intended for the sole use of the addressee, and may contain 
information that is privileged, confidential and exempt from disclosure under 
applicable law. If you are not the addressee you are hereby notified that you 
may not use, copy, disclose, or distribute to anyone the message or any 
information contained in the message. If you have received this message in 
error, please immediately advise the sender by reply email and delete this 
message.




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.



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.