RE: [mssms] Help with a query

Can you post what you have so far? From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Wednesday, June 5, 2013 6:02 PM To: mssms@lists.myitforum.com Subject: [mssms] Help with a query Hey everyone, I need help with a query I'm

RE: [mssms] Permission issue accessing reports

Is this one the site server or from a remote PCs? Have you added the FQDN into the Trusted Site within IE? From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Daniel Corkill Sent: Tuesday, July 2, 2013 11:31 PM To: mssms@lists.myitforum.com Subject:

RE: [mssms] Permission issue accessing reports

the same result whether accessing it from the site server or remotely. From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones Sent: Wednesday, 3 July 2013 8:44 PM To: mssms@lists.myitforum.com Subject: RE: [mssms] Permission issue accessing reports

RE: [mssms] Using VeriSign certs for IBCM

Have you looked at Direct Access? This might be a better option. From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Jeff Krueger Sent: Wednesday, July 31, 2013 1:07 PM To: SCCM List MyItFourm Subject: [mssms] Using VeriSign certs for IBCM Does anyone

RE: [mssms] ConfigMgr Report for user Groups

CM07/CM12 would have no way of knowing when a user was added into a security group. This is really an AD question and I don’t think there is a way to get this data without 3rd party tools like OpsMgr ACS and that assume that you have been collecting the data for a while. From:

RE: [mssms] CM12 HW inventory reporting of Scanners?

Do you still have the link to the CM07 guide on how to capture this data? Based on what they are trying to do in the guide, we can provide advice on how to do with CM12 WITHOUT noidmifs. Noidmifs are evil! From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On

RE: [mssms] Default report query

The parameter @UserID is not blank, it collects the UserID of the person running the report. It isn't do much in CM12 but it will be used a ton in CM12R2 to leverage RBA within SSRS. I'm working on a whole set of blogs/videos that will give details on how it works and how to create report for RBA

RE: [mssms] Default report query

Sent: Thursday, September 19, 2013 12:25 PM To: mssms@lists.myitforum.com Subject: RE: [mssms] Default report query I believe it is used now to localize report names and such. Sent from my Windows Phone _ From: Garth Jones mailto:ga...@enhansoft.com Sent: ‎19/‎09/‎2013 4:18 To: mssms

RE: [mssms] Default report query

...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones Sent: Donnerstag, 19. September 2013 14:10 To: mssms@lists.myitforum.com Subject: RE: [mssms] Default report query RBA does not work in CM12 for SSRS, you need to wait for CM12R2 to use RBA for CM12 SSRS reports

[mssms] Configuration Manager SSRS Report Survey

://fluidsurveys.com/surveys/info-HZv/configmgr-ssrs-report-survey-sept-2 013/ Garth Jones Chief Architect Tel: 613-627-4801 x168 Fax: 613-627-4802 http://www.enhansoft.com/ www.Enhansoft.com http://www.enhansoft.com/ Description: Description: cid:image001.jpg@01CC63FB.974F4EC0 Enhancing

RE: [mssms] Manually deploying reports on Reporting Point

version of the video. Garth Jones Chief Architect Tel: 613-627-4801 x168 Fax: 613-627-4802 http://www.enhansoft.com/ www.Enhansoft.com http://www.enhansoft.com/ Description: Description: cid:image001.jpg@01CC63FB.974F4EC0 Enhancing Your Business http://be.enhansoft.com

RE: [mssms] Manually deploying reports on Reporting Point

Of Garth Jones Sent: Monday, September 30, 2013 1:20 PM To: mssms@lists.myitforum.com Subject: RE: [mssms] Manually deploying reports on Reporting Point Hi Mark, Yup you can manually copy RDS/RDL to the Reporting point. There should be tons of stuff like that on our blog. http

RE: [mssms] OT: MMS absorbed into TechEd 2014

40 Celsius nice!!! From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Michael Niehaus Sent: Tuesday, October 1, 2013 5:29 PM To: mssms@lists.myitforum.com Subject: RE: [mssms] OT: MMS absorbed into TechEd 2014 I lived in Houston for three years.

RE: [mssms] OT: SSRS question, adding dataset breaks report

Check your permission on the view called vCI_ComplianceSummary, I bet is it not the same and other SQL views. Keep in mind that the Query will run based on the permission set by the Data source. From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of

RE: [mssms] SCCM 2012 Link to Computer Details

no there is not, but i was looking into how to do this. Sent from my LG window smart phone, sorry for the shortness . -Original Message- From: Jones, David - Indianapolis Sent: 10/3/2013 8:34 AM To: mssms@lists.myitforum.com Subject: [mssms] SCCM 2012 Link to Computer Details In SCCM

RE: [mssms] Month (1-12) and Year values are blank in CM12

Depending on the report it can take up to 47 days just to get 1 days' worth of data in the report. Are other SWM report working? If so, I would give it more time. From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Monday, October

RE: [mssms] Month (1-12) and Year values are blank in CM12

, at 3:58 PM, Garth Jones ga...@enhansoft.com wrote: Depending on the report it can take up to 47 days just to get 1 days’ worth of data in the report. Are other SWM report working? If so, I would give it more time. From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com

RE: [mssms] Intermittent SSRS authentication issues

Hi Mike, .Is this for CM07 or CM12 .What version of SQL are you running? .Where is SQL ad SSRS are they on the same server? .Is this for all reports or just some reports? .For how long does this problem exist? From:

RE: [mssms] Intermittent SSRS authentication issues

] Intermittent SSRS authentication issues I have tried to re-install the Reporting Point Role but it did not work, how do you reset the SSRS permissions? Regards Mattias Benninge http://myitforum.com/cs2/blogs/matbe/default.aspx On Thu, Oct 31, 2013 at 1:26 PM, Garth Jones ga

RE: [mssms] RE: software inventory

so stupid question but do you have ai classes enabled? Sent from my LG window smart phone, sorry for the shortness . -Original Message- From: Taxter, Latisha Sent: 11/21/2013 1:01 PM To: mssms@lists.myitforum.com Subject: [mssms] RE: software inventory Asset Intelligence, software

[mssms] System Center Universe Contest

Hi Everyone, can you help me win the System Center Universe Contest by Likeing my video on YouTube? http://www.youtube.com/watch?v=jHCmxoT2FSs Thanks you for your help! Garth Jones Chief Architect Tel: 613-627-4801 x168 Fax: 613-627-4802 http://www.enhansoft.com

RE: [mssms] RE: MOF question.

Or you can Union the two queries together. Garth Jones Chief Architect http://www.enhansoft.com/ www.Enhansoft.com http://www.enhansoft.com/ Description: Description: cid:image001.jpg@01CC63FB.974F4EC0 Enhancing Your Business http://be.enhansoft.com/ Description

RE: [mssms] SQL errors

Is SQL remote from CM12? If so I have seen item like this when using caching HD controllers Are you seeing any performance issues? Garth Jones Chief Architect http://www.enhansoft.com/ www.Enhansoft.com http://www.enhansoft.com/ Description: Description: cid:image001

RE: [mssms] Hardware Inventory not processing

No it is no need for SWM but it is used by SWM to create the “Automatic rules”, I recommend turn off both the Shortcut AI data and the auto create SWM rules as they are just messy. Garth Jones Chief Architect http://www.enhansoft.com/ www.Enhansoft.com http

RE: [mssms] SCCM 2007 - script to force hw inventory

Are you CM12? If so why not give them a different HW inv schedule. BTW, I ALWAYS recommend that HW inventory be set to daily. Same thing for Heartbeat discovery too. Garth Jones Chief Architect http://www.enhansoft.com/ www.Enhansoft.com http://www.enhansoft.com

RE: [mssms] Anyone have any cool custom CM2012 reports they'd l ike to share?

This video will tell you . http://www.youtube.com/watch?v=XWR6uzMl_8k Garth Jones Chief Architect http://www.enhansoft.com/ www.Enhansoft.com http://www.enhansoft.com/ Description: Description: cid:image001.jpg@01CC63FB.974F4EC0 Enhancing Your Business http

RE: [mssms] OT: TechEd 2014

I'm going and book your Hotel via the conference, the rate are much cheaper there.. I think $250 is the high end. Garth Jones Chief Architect http://www.enhansoft.com/ www.Enhansoft.com http://www.enhansoft.com/ Description: Description: cid:image001.jpg@01CC63FB.974F4EC0

RE: [mssms] Customizing default reports in SCCM 2012

-2012-R2-SSRS-Reports-in-BIDS.aspx Garth Jones Chief Architect http://www.enhansoft.com/ www.Enhansoft.com http://www.enhansoft.com/ Description: Description: cid:image001.jpg@01CC63FB.974F4EC0 Enhancing Your Business http://be.enhansoft.com/ Description

RE: [mssms] SRS Reports in CM12 not showing up on the client

Do you get an error when you connect to the SSRS site? Have you enabled remote errors on your SSRS site yet? Garth Jones Chief Architect http://www.enhansoft.com/ www.Enhansoft.com http://www.enhansoft.com/ Description: Description: cid:image001.jpg@01CC63FB.974F4EC0

RE: [mssms] SRS Reports in CM12 not showing up on the client

I don’t recommend do this as this does not solve the problem, it only masks it. Garth Jones Chief Architect http://www.enhansoft.com/ www.Enhansoft.com http://www.enhansoft.com/ Description: Description: cid:image001.jpg@01CC63FB.974F4EC0 Enhancing Your Business http

RE: [mssms] SSRS Node Missing

I would re-install the RP on the server to see if they fixes the issue. Garth Jones Chief Architect http://www.enhansoft.com/ www.Enhansoft.com http://www.enhansoft.com/ Description: Description: cid:image001.jpg@01CC63FB.974F4EC0 Enhancing Your Business http

RE: [mssms] RE: Patch progress report?

14th you had 24%? Garth Jones Chief Architect http://www.enhansoft.com/ www.Enhansoft.com http://www.enhansoft.com/ Description: Description: cid:image001.jpg@01CC63FB.974F4EC0 Enhancing Your Business http://be.enhansoft.com/ Description: Description: Description

RE: [mssms] Changing the SQL Service Account PW

Basically John is right now you MUST change it via the SQL Server Configuration Manager. And not from Services in control applet. Garth Jones Chief Architect http://www.enhansoft.com/ www.Enhansoft.com http://www.enhansoft.com/ Description: Description: cid:image001.jpg

RE: [mssms] Time zone thru sccm report

Yes you can get that. Look at win32_timezone WMI class. Garth Jones Chief Architect http://www.enhansoft.com/ www.Enhansoft.com http://www.enhansoft.com/ Description: Description: cid:image001.jpg@01CC63FB.974F4EC0 Enhancing Your Business http://be.enhansoft.com

RE: [mssms] SCCM 2012 - Software metering issue for Visio and Project

Stupid question but did you create SWM rule for Visio and Project? Garth Jones Chief Architect http://www.enhansoft.com/ www.Enhansoft.com http://www.enhansoft.com/ Description: Description: cid:image001.jpg@01CC63FB.974F4EC0 Enhancing Your Business http

[mssms] RE: HW Inventory size limit

Just as a side note 50 MB is the max, if you are going over 50 MB, A. I want to know about it, and understand why, it is one of my pet peeves that 50 MB is a hard code limit. B. Turn off the bad inventory tasks (AI Shortcuts) is a big a fender. Garth Jones Chief Architect

[mssms] RE: Get the SYSTEM_OU_NAME without the duplicate rows

on sys.ResourceID = SC.ResourceID group by sys.Netbios_Name0, SC.System_Container_Name0 Order by sys.Netbios_Name0 Garth Jones Chief Architect www.Enhansoft.comhttp://www.enhansoft.com/ [Description: Description: cid:image001.jpg@01CC63FB.974F4EC0]http

[mssms] RE: Last patch and last reboot date

Ok, I will bite, why do you care about the date of the last Software Update that was installed? How will that be useful information at all? Garth Jones Chief Architect www.Enhansoft.comhttp://www.enhansoft.com/ [Description: Description: cid:image001.jpg@01CC63FB.974F4EC0]http

RE: [mssms] How to get a list of browsers, versions, plug-ins, and browser history?

What is the end goal? Why do you care about website history? Keep in mind that InPrivate browsing will not have any history so…. IMO this info should come from your firewall not CM07/CM12. Garth Jones Chief Architect www.Enhansoft.comhttp://www.enhansoft.com/ [Description: Description

[mssms] RE: Does file collection still work in SCCM 2012 SP1?

Yes it does but... I generally don't recommend using it. Why are you having problems with it? Garth Jones Chief Architect www.Enhansoft.comhttp://www.enhansoft.com/ [Description: Description: cid:image001.jpg@01CC63FB.974F4EC0]http://www.enhansoft.com/ Enhancing Your Business [Description

RE: [mssms] OT: Remote Desktop Connection Manager 2.7

Hi Janus, I love this tool too! Do you remember what session you saw RDCM 2.7 in? By chance is it visible within the video? If you can see it within the Video for that session, I was going to try an email/tweet the presenter to see if I (and others) could get a copy of it! :) Garth Jones

[mssms] RE: Computer performance

Have you looked a Windows Experience Index. This will give you a good idea as to what is the minimum value to get acceptable performance. Garth Jones Chief Architect www.Enhansoft.comhttp://www.enhansoft.com/ [Description: Description: cid:image001.jpg@01CC63FB.974F4EC0]http

[mssms] RE: Reports vs queries

Ok, but if it is a one off thing, then queries are generally fine but if it is not a one off then I would recommend SSRS reports and use the email feature to create them off hours. Garth Jones Chief Architect Tel: 613-627-4801 x168 Fax: 613-627-4802 www.Enhansoft.comhttp://www.enhansoft.com

RE: [mssms] CM 2012 Reporting Issue

BTW The simplest way to reset the Reports is to re-install the reporting point. There are other ways but this is the simplest way. BBTW, A copy of all the original RDL is sit on your RP server under the Reports folder. Garth Jones Chief Architect Tel: 613-627-4801 x168 Fax: 613-627-4802

[mssms] RE: RBA for Reporting administrators

to use the MS DS when I upload them. These blogs/ videos will get you started on that part. http://be.enhansoft.com/post/2010/08/26/How-to-Change-the-SSRS-Datasource.aspx https://www.youtube.com/watch?v=XWR6uzMl_8k Garth Jones Chief Architect Tel: 613-627-4801 x168 Fax: 613-627-4802

[mssms] RE: Reporting question

/myitforumwp/2011/10/04/hardware-inventory-mof-edit-for-net-frameworks-updated-with-v1/ Hopefully she will chime in as to where it is stored. Garth Jones Chief Architect Tel: 613-627-4801 x168 Fax: 613-627-4802 www.Enhansoft.comhttp://www.enhansoft.com/ [Description: Description

RE: [mssms] RE: Patch Reporting Help

dbo.v_FullCollectionMembership_Valid FCMV ON cs.ResourceID = FCMV.resourceID and FCMV.CollectionID = @col where ai.Title = @UDL and cs.status != '3') as 'NONCompliant' Garth Jones Chief Architect Tel: 613-627-4801 x168 Fax: 613-627-4802 www.Enhansoft.comhttp

[mssms] RE: Reporting question

join dbo.v_GS_INSTALLED_SOFTWARE GSIS on RV.ResourceID = GSIS.ResourceID Where RV.Netbios_Name0 = @PC) Order By ARP.DisplayName0 [cid:image002.png@01CFCC78.9A7870C0] Garth Jones Chief Architect Tel: 613-627-4801 x168 Fax: 613-627-4802

[mssms] RE: Reporting question

BTW the dbo.v_Add_Remove_Programs SQL view existing within CM07 too. Garth Jones Chief Architect Tel: 613-627-4801 x168 Fax: 613-627-4802 www.Enhansoft.comhttp://www.enhansoft.com/ [Description: Description: cid:image001.jpg@01CC63FB.974F4EC0]http://www.enhansoft.com/ Enhancing Your Business

[mssms] Bitlocker

My Google skills are failing me this morning or I need more coffee…. How can you convert a Bitlocker drive from “Used Space Only Encrypted” to “Fully Encrypted”? Garth Jones Chief Architect Tel: 613-627-4801 x168 Fax: 613-627-4802 www.Enhansoft.comhttp://www.enhansoft.com/ [Description

[mssms] RE: Bitlocker

...@lists.myitforum.com listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com on behalf of Garth Jones ga...@enhansoft.commailto:ga...@enhansoft.com Sent: Thursday, September 11, 2014 9:55 AM To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com Subject: [mssms] Bitlocker My Google

RE: [mssms] RE: Bitlocker

Apparently that is not good enough for one of the compliance standards (maybe PCI), or at least that is what I'm being told. BTW I did find the GPO to force full encryption.. It's an SSD drive so we will see how on it take to encrypt! Garth Jones Chief Architect Tel: 613-627-4801 x168 Fax

[mssms] RE: Query for Systems Not in a Certain OU

You will need a subselect query. These blog post will help you. http://be.enhansoft.com/post/2014/09/17/The-Subselect-Query.aspx http://be.enhansoft.com/post/2014/09/24/Subselect-Query-for-SCCM-Queries-or-Collections-(WQL).aspx From: listsad...@lists.myitforum.com

RE: [mssms] Able to run HW inventory on 1 WMI class every hour?

This sound like you should be looking at SCOM for this. I'm curious why you need to get the inventory every hour. BTW to answer your question yes you can do this. This blog will help you.

RE: [mssms] Document SCCM 2012 site

Smsmap work for CM12R2 too. From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Nemec, Dale Sent: Wednesday, October 29, 2014 12:48 PM To: mssms@lists.myitforum.com Subject: RE: [mssms] Document SCCM 2012 site I was wondering the same thing as the original

RE: [mssms] Document SCCM 2012 site

Here is script to document your CM12 site. http://www.enhansoft.com/pages/downloads.aspx -Original Message- From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Alicea, Gabriel Sent: Wednesday, October 29, 2014 9:54 AM To: mssms@lists.myitforum.com

[mssms] RE: Need help with the case statement in a report query

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

RE: [mssms] Hardware Inventory Issues

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]

RE: [mssms] OT: New RDCMan! Finally!

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:

[mssms] RE: CCMEXEC is taking up over 3gb of RAM

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

RE: [mssms] RE: CCMEXEC is taking up over 3gb of RAM

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:

RE: [mssms] RE: CCMEXEC is taking up over 3gb of RAM

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

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

RE: [mssms] query Add Remove Programs (32 and 64)

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

RE: [mssms] query Add Remove Programs (32 and 64)

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:

[mssms] RE: Collection of machines online is last 1day?

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

RE: [mssms] SCCM 2012 R2 SiteBackup

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,

RE: [mssms] Summarization - Collection in console

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

RE: [mssms] Summarization - Collection in console

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

RE: [mssms] Summarization - Collection in console

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

[mssms] RE: Changing SCCM port

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,

RE: [mssms] SCCM 2012 reports not running for standard user

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

RE: [mssms] SCCM 2012 reports not running for standard user

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:

RE: [mssms] My turn to retire

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

RE: [mssms] Permissions to SSRS reports

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.

RE: [mssms] Wow ? Look how invol ved reading the Windows 10 Win d ows Update log may become

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

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.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Rod Trent Sent: Wednesday, March 4, 2015 10:18 AM To:

[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,

[mssms] RE: Help with SQL for report

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

RE: [mssms] RE: Which of these options would cause the least impact on our site server?

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

[mssms] RE: Help with SQL for report

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

RE: [mssms] RE: Query Help

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

[mssms] RE: OT: Licensing SCCM Distribution Points

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:

[mssms] RE: All SW Query Help

, 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 Y

RE: [mssms] Hardware Asset Inventory management with SCCM

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

Re: [mssms] SCCM PowerShell to pull report information

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

Re: [mssms] SCCM PowerShell to pull report information

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

[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/> [Description: Description: cid:image001.jpg@01CC63FB.974F4EC0]<http://www.enhansoft.com/> Enhancing Your Business [Description: Description: Description:

[mssms] RE: Application Catalog Usage

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:

Re: [mssms] Hardware Asset Inventory management with SCCM

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

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

[mssms] RE: Hinv not running as scheduled

sad...@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.

[mssms] Re: Query help

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

[mssms] RE: Software Metering

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

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

<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

[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] On Behalf Of Corkill, Daniel Sent: Monday, February 27,

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

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

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

te0, 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/> [De

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

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/&g

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

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:

  1   2   >