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...

Just got a chance to look at this now and it was really helpful. Works perfect. STAR

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...

Good point...early morning coding. The brain never functions at it peak.

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...

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.

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...

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...

She's working good and delivering acurate results. You two have been a tremendous help. You get stars!

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...

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!

'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 =...

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

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.

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 =...

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?

Would a collection work or do you think htat the dictionary object would be a better choice?

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...

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.

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...