Search results for query: *

When you recorded the answer file (.iss), did the program prompt for restart? If yes, was it possible NOT to reboot. If yes, try recreating the answer file choosing not to restart and in your SMS program specify that SMS Restarts the Computer.

When I first read your post, I copied your query and pasted it into an SMS report. The report ran without incident, although nothing was returned. How are you running the query, beside, via QA?

What's the extact message that SMS displayed?

I've never seen so many conditions on a "join on", but that doesn't mean it can't be done .... it's sort of like your "where" statement. Try this: select sys.Netbios_Name0, summ.id, summ.product, CASE WHEN ps.LastState=105 THEN '+' ELSE '-' END as C088 from v_R_System sys join...

Add arp.Version0 to your "Select" statement ... the is Version0 from v_GS_ADD_REMOVE_PROGRAMS.

I used the following statements in a report display the AD OU in which a system resides. The AD OU path is parsed into several entries with the last one containing the full path. I selected the last entry by using "Top 1", sort in descending order, and building a temp table with the reversed...

Use User_Name0 from v_R_System.

Join v_RA_System_SystemOUName, via ResourceID, and use System_OU_Name0.

Your missing "JOIN v_FullCollectionMembership fcm On arp.ResourceID=fcm.ResourceID" from the queries for "Crystal Reports for Exchange" down ... that's why the message regarding "fcm" table prefix. I would also recommend that in your LIKE statements use only one "%", which represents any string...

Just off the top of my head, I would: 1. Write a VBScript to create a NOIDMIF that contains information found under "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Mobile Client\Software Distribution\Execution History\System". Each subkey represents an SMS package id, which has program name...

Oops, I made a mistake .... One needs to join to v_GS_ADD_REMOVE_PROGRAMS to v_FullCollectionMembership, via ResourceID, and check CollectionID in v_FullCollectionMembership. Try this: SELECT arp.DisplayName0 as 'Adobe Acrobat 6.0 Standard', Count(arp.ProdID0) AS 'Count', arp.Version0 FROM...

You added "adv.CollectionID", but did not specify the table prefix or join to v_Collection. Try this: SELECT arp.DisplayName0 as 'Adobe Acrobat 6.0 Standard', Count(arp.ProdID0) AS 'Count', arp.Version0 FROM v_GS_ADD_REMOVE_PROGRAMS arp JOIN v_Collection adv On arp.ResourceID=adv.ResourceID...

Creating a package that invokes regedit can advertized to one or several systems. I can script, but why go through the trouble of writing one when regedit is so much easier!

You can export the registry changes from a system with the changes already in place and the create a package that invokes: regedit /s <export_filename> This will run regedit in silent mode and import the registry entries from the export file created above. This is much easier than scripting...

Rather than using a script, export the key using regedit, modify the export file to delete the key ("-" in front of key name ... http://www.robvanderwoude.com/index.html), then use the command line "regedit.exe /s <name of export file>" I like using regedit because its made for manipulating the...

Trying specifying your SQL Server as <servername>\<instance name>,e.g. sqlserver1\someinstance

wmjoann, In SSC, under All Task->Symantec AntiVirus->Client Administrator Only Options->Security tab provides the ability remove the password requirement for removal.