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 Chriss Miller 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.
Just got a chance to look at this now and it was really helpful. Works perfect. STAR -
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
Good point...early morning coding. The brain never functions at it peak. -
Deciphering an Error Message
I have a new question then. Perhaps someone has an idea of how to do this. If I'm loading a list of strings into a dictionary object and there are duplicate values in the list, is there a way to have the dictionary ignore the duplicate and continue on? Scenario: Test 1 Test 2 Test 2 Test 3... -
Deciphering an Error Message
I may have found the problem. One of the files has four identical strings in it. I guess it's just telling me that that string is already in my dictionary. -
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... -
Anti-Spyware program
We have about 2800 2K/XP computers at my work, and we use Ad-aware 6.0 and Spybot 1.3 to remedy computers with spyware. To try to limit spyware we use internet filters. We also use Trend Micro for our virus scan right now and they are going to be producing a spyware protection feature on an...- MISMCSA
- Post #4
- Forum: Virus/Spyware discussion
-
search for discrepencies in file contents
She's working good and delivering acurate results. You two have been a tremendous help. You get stars! -
search for discrepencies in file contents
It works to a certain extent. However, a new issue has arisen. I am comparing strings in this script and it just so happens that there are spaces after a few of these IDs and it recognizes the spaces as being a different ID. Is there an adjustment, that can be made within the code, that will... -
search for discrepencies in file contents
As I was reading through my code I was thinking it wasn't an array. I was just replacing the value every time, wasn't I? Anyway, what you gave me apparently worked, but I need to verify the results. You guys have been extreemely helpful! -
search for discrepencies in file contents
'Define Variables Dim fso, ReadFile, ProDictionary, StdDictionary, arrUserIDList Dim strID, strUserID Set ProDictionary = CreateObject("Scripting.Dictionary") 'Set StdDictionary = CreateObject("Scripting.Dictionary") Set fso = CreateObject("Scripting.FileSystemObject") Set ReadFile =... -
search for discrepencies in file contents
I'm getting a type mismatch error with Ubound in the code below. Any ideas? For i = 0 to Ubound(arrUserIDList) If Not ProDictionary.Exists(arrUserIDList(i)) Then WriteFile.WriteLine arrUserIDList(i) End If Next -
search for discrepencies in file contents
Yea, sorry. I did not ask that question well at all. I must have been thinking to hard while I was typing. I'm going to try a couple things and see what happens. thanks for your help. -
search for discrepencies in file contents
How can if the ProDictionary has all of the user IDs in it? 'Define Variables Dim fso, ReadFile, ProDictionary, StdDictionary Dim strID Set ProDictionary = CreateObject("Scripting.Dictionary") 'Set StdDictionary = CreateObject("Scripting.Dictionary") Set fso =... -
search for discrepencies in file contents
I'm looking at example code for a dictionary object and the examples suggest typing in individual items. Dim cars Set cars = CreateObject("Scripting.Dictionary") cars.Add "a", "Alvis" cars.Add "b", "Buick" cars.Add "c", "Cadillac" How can I load my list of 4000 users into it? -
search for discrepencies in file contents
Would a collection work or do you think htat the dictionary object would be a better choice? -
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... -
Editing reports in SMS 2003
Well I can add COMPUTE SUM(number), SUM(number) at the end of the initial query you are talking about and it will produce a grand total for the columns. So, there is a way to do it, it just doesn't look real clean. It'd be nice to format the table.- MISMCSA
- Post #3
- Forum: Microsoft: SMS (Systems Management Server)
-
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)
