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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bslintx

    INSERT data into local Access DB from remote Access DB

    ty genomon for responding... i cannot link to the access files because they are dynamic - how many there are and the names change....hence using the file system object to find these files on-the-fly i have it retrieving and inserting into an access database as so: pseudo code - For each file...
  2. bslintx

    INSERT data into local Access DB from remote Access DB

    ...trying to insert data from one Access database from another...I can get the following query to work on a remote Access database... sSQL = "SELECT * FROM Activity IN """ & sRtdPath & """" however, I need to include an inner join like so: sSQL = "SELECT DISTINCT Machine.DisplayField...
  3. bslintx

    VBScript to manage AD

    assuming you have permissions to do so...(creating/modifying objects in AD)...then is there any reason why you cannot use the Active Directory Users and Computers tool in adminpak.msi?
  4. bslintx

    Parse out a string

    you could do a replace and split all by -...however, splitting may be a moot point if you cannot guarantee 'needed' dashes or commas in the string...therefore a regular expression may help <% s = Replace("Example130-Your Analysis Bus-0.00-W-20032,Help130-My Analysis...
  5. bslintx

    Regular expression

    update: splitting DETAILS not needed because it has passed the pattern match - delimited with commas If IsValidRegEx(DETAILSPATTERN,DETAILS) Then VMS_Convert_HOSTS.WriteLine ReportName & "," & EntryDate & "," & DETAILS Else ' ... End If'
  6. bslintx

    Regular expression

    ...& ReportSaveAs, True) VMS_Convert_HOSTS.WriteLine "REPORT NAME,ENTRY DATE,ID,IP ADDRESS,MAC ADDRESS,HOST NAME" CONST DETAILSPATTERN = "^\s*(\d{1,3}(\.\d{1,3}){3},(unspecified|[A-Fa-f0-9]{2}(:[A-Fa-f0-9]{2}){5}),(\w|-|\W){2,16})\s*$" For Each file in oFolder.Files If...
  7. bslintx

    Regular expression

    ...shyed away from them. but, i have a couple questions in regards to the following snippet (the test script to validate the pattern you gave me)... * IP:, MAC:, Host Name: were replaced with delimited commas to eventually be imported into a SQL database - hence the slight change Function...
  8. bslintx

    Regular expression

    ...expression. The pattern is (pseudo): (The characters IP:) (a space) (An ip address) (a space) (The characters MAC:) (a space) (a mac address *** either a mac address OR the word 'unspecified') (a space) (The characters Host Name:) (a space) (computer name *** follows active dir rules IE...
  9. bslintx

    SQL statement - Multiple COUNT

    Thanks bborissov! I was 'googling' while you posted and came up with something very similar...i was surprised to see a fast reply! a star for what ultimately would have been the answer Thanks
  10. bslintx

    SQL statement - Multiple COUNT

    I ended up with a 'pivoting' solution: SELECT HOST, COUNT(CASE WHEN Severity = 'Category I' THEN 1 END) AS [Cat I], COUNT(CASE WHEN Severity = 'Category II' THEN 1 END) AS [Cat II], COUNT(CASE WHEN Severity = 'Category III' THEN 1 END) AS [Category III] FROM table GROUP BY [HOST]; Thanks
  11. bslintx

    SQL statement - Multiple COUNT

    ...FROM table GROUP BY HOST but returns: HOST Cat I Cat II Cat III comp1 73622 260071 270901 comp2 73622 260071 270901 comp3 73622 260071 270901 * host field is correct, however counts are not by host but database overall... should return something like: HOST Cat I Cat II Cat III comp1 3...
  12. bslintx

    help with time counter

    WScript.Sleep(5000) WScript.Echo("You delayed this message by 5 seconds") post relevant code if sleep is not what is needed
  13. bslintx

    Please do not laugh at my first login.vbs script.

    google is your friend keywords: vbs active directory logon scripts http://www.computerperformance.co.uk/Logon/logon_scripts.htm
  14. bslintx

    Combining several scripts

    you may want to consider using a .hta...it's a GUI representation of your vbs code... i intentionally left out move to ou and remove functions...hopefully the way it's written...you can follow the logic...if not...let us know...good luck save as FindUser.hta <html> <head> <title>User...
  15. bslintx

    how to insert ado recordset data with javascript

    again....speed i understand the loop is used against the getstring ...i also understand as i mentioned i may as well use get rows...a 2d array....the loop is FAR slower in generating the recordset reslts....the code works as is if on server side...no loops...just getstring.....it's lightning...
  16. bslintx

    how to insert ado recordset data with javascript

    tsuji, i truely appreciate the response...unfortunately...using the for loop pretty much defeats the purpose of me using getstring...i may as well use getrows i therefore used fso to generate a comma delimited getstring and this satisfies the speed i need vs looping yes...i close the...
  17. bslintx

    how to insert ado recordset data with javascript

    hey all... i'm retrieving a recordset via javascript and ado. the ado method i am using is getstring. i am used to server side code...and i was wondering why i cannot get a string returned by getstring to work correctly in the following: <script> var sDatabasePath = "tree.mdb"; var cn =...
  18. bslintx

    trying to query exchange server with WQL and like/wildcard

    also...the * was the wrong one posted ...all demos used %...it just happened to be the last one i was experimenting with on a copy/paste/post...good eye dm4ever
  19. bslintx

    trying to query exchange server with WQL and like/wildcard

    unfortunately yes...i can't for the life of me understand why it doesn't work....if someone has successfully ran the like in this situation...please let me know....it would be appreciated.... btw....i can obviously grab all mailboxes (2000+) in this case and loop with an instr but i'd rather...
  20. bslintx

    trying to query exchange server with WQL and like/wildcard

    forgot to mention...it's a .hta....i'm sure that was inplied w/ the innerhtml but just in case...thanks

Part and Inventory Search

Back
Top