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 database route what would be the suggested way
to set that up? Is there a specific replication task that can be
Hi All,
After long time, my new e-book about SCCM is ready, you can download it FREE
from https://goo.gl/xBwn3b
The e-book has 197 pages, 33 chapters and over 160 PowerShell scripts, so you
can automate (almost) all SCCM tasks
Regards,
Raphael Perez
System Center Specialist | Microsoft MVP
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
Currently on build 1602 planning to go to 1610 in the next 30 days.
We do use RBA and I have added the service account they are using to perform
queries as a "Read Only Analyst".
SQL Server 2014
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of Garth
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
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
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 |
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
Have you verified content on the DP? I've seen weird issues with HP BIOS
that stung me a few times. I would test things manually, create the
Application, and then deploy only to find out it is missing files. It is
standard behavior with HP BIOS to delete some of the files after it has run
New morning, new app, two bin files included for good measure.
Deployed and ran, both bin files in the cache, job failed anyway, the bin files
are not compatible between different bios update exe’s (who knew).
Made a new compatible bin file copied it into the ccmcache ran the command
manually
I checked out the request filtering as suggested and found the following, I've
removed the bin line for now and will test in the am with new packages/apps.
Also had a chance to test on a separate setup, similar behaviour, bin file
stripped out, it appeared again once we did an 'update
11 matches
Mail list logo
