in EMEA.
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of Sherry Kissinger
Sent: Tuesday, April 04, 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
:)
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
mailto:listsadmin@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 / Cordialem
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
Informa
oning Tools & Lifecycle Sharepoint Site
> <http://wssamer.sanofi.com/ws/AutomationCenterProvTools/Documents/Forms/AllItems.aspx>
> (for
> internal use only)
>
>
>
> *From:* listsad...@lists.myitforum.com [mailto:listsadmin@lists.
> myitforum.com] *On Behalf Of *Gar
On
Behalf Of Garth Jones
Sent: Tuesday, April 04, 2017 7:32 AM
To: 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.my
As a side note:
We've been chasing excessive collection evaluations for some time (we have over
5,000 collections now)
There are also 2 "Exclude Collections" in the previously created collections
and this collection is scheduled to evaluate every day.
Our environment:
All Virtual
SCCM 1606
1 C
: 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.
Neither. I'd use this one. resourceid is resourceid is resourceid. there
is no reason to join sms_r_system in the subselect itself. Extra work for
SQL, and not needed. We've done this type of 'not in' subselect lots of
times.
select
SMS_R_SYSTEM.ResourceID,
SMS_R_SYSTEM.ResourceType,
SMS_R
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
Hel
ull Sql version.
>
>
>
> Any idea if it would be covered under the CM license?
>
>
>
> *From:* listsad...@lists.myitforum.com [mailto:listsadmin@lists.
> myitforum.com] *On Behalf Of *Wendell Hutchison
> *Sent:* Friday, March 3, 2017 11:12 AM
> *To:* mssms@lists.my
...@lists.myitforum.com] On
Behalf Of Wendell Hutchison
Sent: Friday, March 3, 2017 11:12 AM
To: mssms@lists.myitforum.com
Subject: RE: [mssms] RE: SQL Query question / best practice
Use Express. It is free and if you are only storing/sharing data it will work
for your purpose.
From: listsad
istsad...@lists.myitforum.com] On Behalf Of Enley, Carl
Sent: Wednesday, March 1, 2017 1:25 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: RE: [mssms] RE: SQL Query question / best practice
Thanks for all of the replies, I was thinking the same thing about not lett
, March 1, 2017 1:25 PM
To: mssms@lists.myitforum.com
Subject: RE: [mssms] RE: SQL Query question / best practice
Thanks for all of the replies, I was thinking the same thing about not letting
them in. Hopefully it is not an impossible fight to win with management.
Assuming I go down the replica
. Would this secondary
SQL server be required to have the Config Mgr client installed
Thanks
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of Sherry Kissinger
Sent: Wednesday, March 1, 2017 10:29 AM
To: mssms@lists.myitforum.com
Subject: Re: [mssms] RE: SQL
I agree with Troy--setup a replica database. We have two "classes" of
people that desperately feel they need access to our data. For 1 set, the
replica is what they get, and it works perfectly for their needs. There's
another set of people who, through mainly political maneuvering, convinced
the
f Of Garth Jones
Sent: Wednesday, March 1, 2017 10:02 AM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: SQL Query question / best practice
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
We do a good amount of this, feeding to and from lots of different tools, JAMF,
CA SAM, CA APM, and a few others.
Most of these tools use a single query to gather data, there really isn't much
ad-hoc reporting. We vet the query and ensure it is properly written and
performs well. Our SQL server
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
Beh
Give them access to an offline (replica/log-shipped) copy of the site database,
hosted on a remote (or other) SQL Server and let them go to town :)
No need to provide access to CAS or primary site databases. Avoid doing that
for a number of reasons...
Troy L. Martin | Technical Architect
1E |
om: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>
[mailto:listsad...@lists.myitforum.com] On Behalf Of Linkey, Mike
Sent: Friday, January 03, 2014 3:00 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] RE: SQL query question - convery to G
Errr, looks like I spoke too soon.
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of Dzikowski, Michael
Sent: Friday, January 03, 2014 3:04 PM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: SQL query question - convery to GB or MB
Ya! That got me
:00 PM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: SQL query question - convery to GB or MB
I am not in front of a SQL server, but I think this will get you MB.
select Netbios_Name0 as 'Server Name', Description0, InitialSize0*1024 as '
Page File Initial Size', Maximu
I am not in front of a SQL server, but I think this will get you MB.
select Netbios_Name0 as 'Server Name', Description0, InitialSize0*1024 as '
Page File Initial Size', MaximumSize0*1024 as 'Page File Max Size',
TotalPageFileSpace0*1024 as 'Total Page File Space', TotalPhysicalMemory0*1024
as
24 matches
Mail list logo
