Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SMS query troubles
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...- MISMCSA
- Thread
- Replies: 0
- Forum: Microsoft: SMS (Systems Management Server)
-
Adding some kind of progress notification to a script.
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... -
Deciphering an Error Message
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... -
search for discrepencies in file contents
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... -
SMS Report Queries - can you query a query?
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...- MISMCSA
- Thread
- Replies: 2
- Forum: Microsoft: SMS (Systems Management Server)
-
Editing reports in SMS 2003
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- MISMCSA
- Thread
- Replies: 2
- Forum: Microsoft: SMS (Systems Management Server)
-
For...Next Loop & concatenating a variable name through it?
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... -
Best Free VBScript Editor?
What do you guys feel is the best free option available. I just tried sitepad pro and textpad and I'm fairly unimpressed. -
Access username from the command line?
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... -
How to read filenames into an array.
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...
