Hello All,
I've been working on a custom report that is based on the Inactive Clients
Details report included in CM 2012, but includes additional info. In looking
at the default report, it seems to be getting this data by returning all
systems where v_CH_ClientSummary.ClientActiveStatus = 0.
Just ask you McAfee folks, when the next time they quarantine system32.dll
will be?
I Loathe their AV product.
Christopher Catlett
Consultant | Detroit
Sogeti USA
Office 248-876-9738 |Fax 877.406.9647
26957 Northwestern Highway, Suite 130, Southfield, MI 48033-8456
www.us.sogeti.com
Amen
Sent from my Windows Phone
-Original Message-
From: christopher.catl...@us.sogeti.com christopher.catl...@us.sogeti.com
Sent: 8/23/2013 8:08 AM
To: mssms@lists.myitforum.com mssms@lists.myitforum.com
Subject: RE: [mssms] McAfee and SCEP
Just ask you McAfee folks, when the next
Could be related to the Obsolete0 flag... for example, in order validate that
you have active clients, you'd want to use something like this:
SELECT *
FROM v_R_System s
WHERE ISNULL(s.Obsolete0, 0) 1 AND s.Client0 = 1
If you add a condition to your query to include
WHERE (
I am out of the office until Aug. 26th.
This e-mail, including any attached files, may contain confidential and
privileged information for the sole use of the intended recipient. Any review,
use, distribution, or disclosure by others is strictly prohibited. If you are
not the intended
Does Microsoft make updated EP templates available anywhere? I can't seem to
find any. How do people deal with SQL exclusions? It looks to me like the
templates would only work for a specific version of SQL and only if it's
installed in the default location. Can I just wildcard the exe
Have you looked at the ones in the SCCM console?
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of Marcum, John
Sent: Friday, August 23, 2013 7:49 AM
To: SMS List (mssms@lists.myITforum.com)
Subject: [mssms] Updated EP Templates
Does Microsoft make
right click on Antimalware policies, choose import, have fun.
On Fri, Aug 23, 2013 at 4:48 PM, Marcum, John jmar...@babc.com wrote:
Does Microsoft make updated EP templates available anywhere? I can't
seem to find any. How do people deal with SQL exclusions? It looks to me
like the
Yes, I mean do they release newer ones. For instance SQL 2012. Could I just
wildcard the SQL process locations and use one custom policy for all versions
of SQL?
John Marcum
Sr. Desktop Architect
Bradley Arant Boult Cummings LLP
Try changing this one:
OR ISNULL(v_R_System.Obsolete0, 0) = 1
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of andrew.ber...@everestre.com
Sent: Friday, August 23, 2013 8:59 AM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: CM 2012 SSRS Reporting
In CM12 I created Laptop, workstation and server collections. I originally had
the membership setup as direct (during testing) and noticed that no new
machines are in these collections.
We mark all out laptops with the prefix of L and our workstations with W
Is there a way to make a query that
Wildcards are %. If you use a wildcard, you need to use like instead of
=. Here is the query for all devices that start with L:
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
Awesome thanks Ryan!!
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of Ryan
Sent: Friday, August 23, 2013 12:16 PM
To: mssms@lists.myitforum.com
Subject: Re: [mssms] Creating a membership rule query for a device collection
Wildcards are %. If you use a
good point,
i'm not aware of them procuding new ones, but I would imagine that the ones
that are there should be sufficient to build one for SQL Server 2012 (you
can merge policies and make your own)
have you tried using the one for SQL Server 2008 and verifying if that's
sufficient ?
On Fri,
Note that the underscore is also a wildcard in SQL/WQL as are what I call
character classes (similar to regular expressions).
% means 0 or more of any character
_ means 1 of any character
More info at http://www.w3schools.com/sql/sql_wildcards.asp
J
From: listsad...@lists.myitforum.com
Hi,
Is there a HW class that can gather info on input devices like Scanners?
I see a post from CM2007 with a guide to do it with NOIDMIF approach, but
hoping I am just overlooking an existing class name I can just add in CM12.
I don't see anything named with *Scanner* or *Input*.
Thanks.
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
To further build on Jason's comment, you can do some nifty stuff with
character ranges. For example, this is a [convoluted] way of matching 'Dell
Inc.'
Get-WmiObject -Query Select * from Win32_ComputerSystem where Manufacturer
like '[a-d][e-g][l-o][l-o]%'
Made the change and it appears it picked up a few systems, but still off from
the default report. Current SQL syntax is below:
SELECT DISTINCT
v_R_System.Name0
,v_R_System.description0
,v_R_System.User_Name0
,v_GS_SYSTEM_CONSOLE_USAGE.TopConsoleUser0
,v_GS_OPERATING_SYSTEM.Caption0
That's why I keep asking if I can wild card the processes. It looks like out of
the box the SQL 2008 one ONLY works for 2008 (not r2) and ONLY if it's
installed in the default location which nobody does.
[cid:image001.png@01CEA001.371927D0]
John Marcum
Sr.
I don't have the full context of what may have been said, but statements that
indicate Microsoft System Center Endpoint Protection has been discontinued are
completely false. Microsoft has the public preview of System Center 2012 R2
Configuration Manager and Endpoint Protection available for
I believe the incident Mike referenced earlier was later found to have come
from a consulting company/guy trying to generate (or retain existing) business
at one of our customers.
THE SKY IS FALLING!!! DON'T GO THERE!!!
Thanks a ton Brian H for the added reinforcement of the messaging!
property page of the header, repeat
On Thu, Aug 22, 2013 at 6:34 PM, Marcum, John jmar...@babc.com wrote:
Maybe #2 knows about the header?
Typos courtesy of Apple. Sent from my iOS device.
On Aug 22, 2013, at 6:14 PM, Sherry Kissinger slkissin...@sbcglobal.net
sarcastic
Don't fret about this. SCEP is going away, remember?
/sarcastic
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of Marcum, John
Sent: Friday, August 23, 2013 10:49 AM
To: SMS List (mssms@lists.myITforum.com)
Subject: [mssms] Updated EP Templates
Still using GPO's..and we just entered the process executables..works OK.
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com]
On Behalf Of Marcum, John
Sent: Friday, August 23, 2013 8:04 PM
To: mssms@lists.myitforum.com
Subject: RE: [mssms] Updated EP Templates
Mcafee folks do seem to do that a great deal. Not sure if it's directly
connects back to mcafee but it always seems to benefit them.
We couldn't implement bitlocker because mcafee said it had gaping holes that
it's product didn't. Seemed it wasn't very true or was at least true of their
Does anyone have a report that lists all systems missing required updates
in a prompted collection and against a prompted update group?
Do you have a copy of the query from the report you mention?
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of andrew.ber...@everestre.com
Sent: Friday, August 23, 2013 12:00 PM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: CM 2012 SSRS Reporting
The report Compliance 7 - Computers in a specific compliance state for an
update group (secondary) pretty much does this, eh?
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of HS SYS Admin
Sent: Friday, August 23, 2013 12:08 PM
To: mssms
Subject: [mssms]
no that doesn't list what updates are missing from each system
management once one report to look at to show exactly what systems are
missing what updates
On Fri, Aug 23, 2013 at 3:47 PM, Murray, Mike mmur...@csuchico.edu wrote:
The report “Compliance 7 - Computers in a specific compliance
Good afternoon,
I have a question for anyone that may know/offer an opinion/solution for our
reporting requirements within our environment:
Is it possible between SSRS and ConfigMgr 2012 to achieve granular security on
custom folders within Reporting, and those same custom folders be displayed
Or Software Update deployment state by date
I don't see built in reports for this.
I need to know which computers in a collection that installed patches today
(bonus: and rebooted.)
Thank you!
Ivan Lindenfeld
Appreciate the feedback. I don't think the granularity we're looking for is
achievable at this time. Or with R2.
Thanks!
Megan
mjwi...@securemissionsolutions.commailto:mjwi...@securemissionsolutions.com
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of
D'oh... It turns out the guide was actually just a link to the MS
documentation on NOIDMIFs, and didn't actually reference the specific WMI
classes or reg keys or anything related to scanners. I'll keep digging.
On Fri, Aug 23, 2013 at 10:19 AM, Garth Jones ga...@enhansoft.com wrote:
Do you
34 matches
Mail list logo
