-
-
If you received this error message "CREATE PROCEDURE permission denied in database 'SMS_XXX'"
What this means is the "Create Procedure" permission is missing from "Webreport_approle" database role.
To Fix this issue, perform the following:
Open a Query window and execute the following SQL statement:
Grant Create Procedure to [Webreport_approle]
Now you are going to ask why does the Webreport_approle need this permission, the answer is it does and I will show why in another blog post.
-
-
What SUS client log Event ID indicates, "Install success"?
-
-
Select B.ADSite as 'AD Site', Count(B.ADSite) as 'Count'
from
(SELECT
Case
When R.AD_Site_Name0 = '' Then '<No AD Site>'
When R.AD_Site_Name0 = NULL Then '<No AD Site>'
When isnull(R.AD_Site_Name0,'one') = 'one' Then '<No AD Site>'
else R.AD_Site_Name0
End as 'ADSite'--,
FROM v_R_System R) as B
Group by
B.ADSite
Order by
B.ADSite
-
-
What is the command line for MBSA to use the SUS server instead MS catalog?
Answer:
Mbsacli /SUS Http://SMSUG_SUS
-
-
Select Distinct
CS.Name0,
NIC.Description0,
NAC.IPAddress0,
NAC.DefaultIPGateway0
from
dbo.v_GS_COMPUTER_SYSTEM CS,
dbo.v_GS_NETWORK_ADAPTER NIC,
dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC
Where
CS.ResourceID = NIC.ResourceID
and CS.ResourceID = NAC.ResourceID
and NAC.ServiceName0 = NIC.ServiceName0
and NAC.IPAddress0 != ''
and NAC.IPAddress0 != '0.0.0.0'
Order by
CS.Name0,
NIC.Description0,
NAC.IPAddress0,
NAC.DefaultIPGateway0
-
-
What is the command line for MBSA to use the SUS server instead MS catalog?
-
-
What are RODC and why are they more secure? 
-
-
This weeks reading for the self study group is:
| 8.1 Configuring Password and lockout Policies | 13 | 38 |
| 8.2 Auditing Authentication | 6 | |
| 8.3 Configuring Read-Only Domain Controllers | 19 | |
-
-
What are the values and their meanings for the registry entry for AUOptions?
Answer:
2 = Notify of download and install
3 = Automatically download and notify
4 = Automatically download and schedule installation
Yes, there is no 0 or 1 options :-)
-
-
Microsoft System Center Configuration Manager 2007: Configuration 486
Microsoft System Center Operations Manager 2007: Configuration 503
-
-
What are the values and their meanings for the registry entry for AUOptions?
-
-
Rank the software updates in order of important's
- Critical
- Important
- Low
- Moderate
Answer:
- Critical
- Important
- Moderate
- Low
-
-
Which of the following can be deployed via GPSI?
- Batch file (.Bat)
- Command File (.Com)
- Executable (.Exe)
- Visual Basic Scripting Edition (.Vbs)
- Windows Installer (.Msi)
- Windows PowerShell (.Ps1)
- Windows Software Installation Settings file (.Zap)
Answer:
- Windows Installer (.Msi)
- Windows Software Installation Settings file (.Zap)
-
-
Rank the software updates in order of important's
- Critical
- Important
- Low
- Moderate
