Questions tagged [sccm-2007]
32 questions
2
votes
2 answers
Querying for software using SQL query in SCCM
I am looking for specific pieces of software across our network by querying the SCCM Database. My problem is that, for various reasons, sometimes I can search by the program's name and other times I need to search for a specific EXE.
When I run the…

recklessmortal
- 31
- 1
- 5
2
votes
2 answers
My SCCM 2007 SQL Web Report is not displaying results
I created an SCCM SQL report using SQL Management Studio. I then created the following prompts for my Asset Management Office to use on the web report: Publisher, Display Name, and Version.
The Display Name and the Version prompts are both…

The Ratzenator
- 27
- 5
2
votes
2 answers
Problems installing jre-6u30-windows-i586.exe on a Windows 7 x64 system
When I try to install jre-6u30-windows-i586.exe on a Windows 7 x64 system using the NT Authority\System account, I get a 1619 error ( http://msdn.microsoft.com/en-us/library/windows/desktop/ms681385(v=vs.85).aspx) returned to the starting process. …

Keith R.
- 43
- 1
- 8
1
vote
2 answers
Query SCCM from Task Sequence - is it possible?
I have a VBscript which works abolultuly fine on my workstation. It queries SCCM to find out what domain a computer is in. When I run it as part of the task sequence, it fails. Note that this is almost the last step in the task sequence, under…

rd1966
- 185
- 1
- 9
1
vote
1 answer
SCCM does not update software that was installed manually
Client machines are all Windows 10 Pro (64-Bit).
If we were to have MyCompanyApp.msi installed via SCCM, we found that we could update it successfully using SCCM. Everything normal there.
HOWEVER, if I were to run MyCompanyApp.msi locally either by…

ezG
- 391
- 1
- 17
1
vote
2 answers
SQL - Select distinct based on specific columns
My SQL is a little rusty, so bear with me.
I have a query that unions two select distinct statements that pull from different sources. The data from the two select statements overlap, but each pull a date column that are not always populated,…

ssoong
- 157
- 1
- 6
- 18
1
vote
1 answer
SCCM 2012 Perquisite Check "SQL Server service running Account Error"
Getting """SQL Server service running Account Error"
Description as provided
"The logon account for the SQL Server service cannot be a local user account, NT SERVICE\ or LOCAL SERVICE. You must configure the SQL Server service to use a valid…

Shubham Pandey
- 21
- 1
- 4
1
vote
1 answer
Sccm 2007 collection query for particular service not installed in services.msc
Sccm collection query to get the list of machines which do not have "sms host agent" service installed.
There are lot of queries in google related to this, however, they say the state of a service. But i need help to check if the service is…

John Franky
- 1,012
- 1
- 14
- 33
1
vote
1 answer
SCCM 2007 collection Query, not approved machines with particular site code
I am trying to have a sccm 2007 collection query which can populate "not approved" and assigned to site code "AA1" - machines. Any suggestions ?

John Franky
- 1,012
- 1
- 14
- 33
1
vote
1 answer
AdminUI.WqlQueryEngine.dll not found
I recently installed "Configuration_Manager_2012_R2_SDK_Setup.msi", but when i try to build the samples which came with it, its showing a couple of references which are…

Sagar Pilkhwal
- 3,998
- 2
- 25
- 77
1
vote
0 answers
Report old advertisements and packages in SCCM 2007
I would like to find an easy way to list all "old" packages and advertisement.
If I could list them by last date used I would get a good idea of what stuff that could be removed.

user152964
- 31
- 1
- 2
- 5
1
vote
0 answers
Windows 7 x64 bit deployment using SCCM 2007
I have some difficulties regarding deploying Windows 7 x64 bits using SCCM2007.
When the PC gets rebooted it does not show the option to process with Windows 7 x64, I already have x86 version and it comes up with only x86 bits.
Can anyone suggest…

user1847609
- 111
- 3
0
votes
1 answer
System.typeload exception thrown when instantiating object of class SmsNamedValuesDictionary
A System.typeload exception is being thrown when instantiating object of class SmsNamedValuesDictionary.All the assemblies that have to be referred have been referenced correctly.I have to pass this object to WQLConnectionNManager class to connect…

Vineet
- 12
- 8
0
votes
0 answers
Bat file failing to successfully deploy SCCM?
I have deployed a bat file to a device using the with file name as the install line e.g. app.bat
It is a simple one line piece of code:
for /d %I in ("C:\ProgramData\theapp*") do "%~I\theapp.exe"
But this fails to deliver and I I receive a generic…

Codecode1
- 15
- 5
0
votes
0 answers
the software could not be found on any servers at this time : sccm issue
I want to install sapience software and it's available at software center but when I click install it says unable to make changes to your software and in more information it says the software could not be found on any servers at this time . Is…

muniya
- 162
- 2
- 14