Search results for query: *

I'm running SMS 2003. I have this query: SELECT DISTINCT sys.Netbios_Name0, sys.Operating_System_Name_and0, os.LastBootUpTime0, os.TimeStamp FROM v_R_System sys INNER JOIN v_HS_OPERATING_SYSTEM os on sys.ResourceID = os.ResourceID and it is giving this error when I attempt to run...

Are there any methods that will allow me to add progress notification during the running of a script. For example, I have a script that mirrors some data and can take about 1 - 2 minutes. Right now you run the script, it looks like nothing is happening, and then a messagebox pops up at the end...

I get this error message after I try to run this script a second time, after a successful run the first time. Are there values still in the dictionary? Error: This key is already associated with an element of this collection. Code: 800A01C9 Main Part of Code Below.... Description: Will...

This is the scenario. I have two text files with lists of user IDs. One file is a list of random user IDs and the other is a masterlist containing all user IDs that are part of a group. What I want to do is write a script that cycles through every ID that is in list of random users and...

I've got ana SMS Report that returns information about installed and mising patches on computers. The information that this query produces is thrown into the web reporting tool. I want to query some of the information in the first query so I can manipulate that data. Is there a way to query...

I was wondering if any of you know how to sum a column in SQL. For example, If I have 2 platforms WinXP and Win2k and I have 2 unsuccessful patch installs for XP and 7 for 2k, then the total unsuccessful installs (9) would be totaled at the bottom of the column. Thanks

I could use some suggestions here. What I am trying to do is set up a loop that will check to see if these files exist. Rather than hardcode these files into an If...Then logic fest. The loop below is supposed to check and see if a file exists starting with TargetFile4 and working down to...

What do you guys feel is the best free option available. I just tried sitepad pro and textpad and I'm fairly unimpressed.

From the command line, how do I enter the username of a user logged on to the system? Example: c:\Robocopy c:\Documents and Settings\ & Username & \Documents /MIR What do I plug in for user name? I know the location of the username is...

I'm trying to find a way to make a backup of files within a folder and store them in a second folder. Here is the scenario I am looking at. Scenario (better explanation): A & B are both folders, I have file1, file2, and file3 in A. I have file2, file3, and file7 in B. The script has to look...