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

    Windows7 Script Problem

    Hi, I'm hoping somebody can help me please? I've created a script to install some software, so that it can be deployed through our deployment solution. The script works successfully on Windows XP desktops, but not on Windows 7 desktops. It will only run on a Windows 7 desktop if you manually...
  2. wotsit

    Problems with sh runn and cisco certificates

    Hi, I'm hoping somebody can help me as my networking knowledge is very limited. We have some change tracking software which monitors network devices for any changes. At the moment, the reporting side of it is not working. This is due to the CISCO self-signed certificate on the device showing...
  3. wotsit

    Exporting Results To File

    Thank you for your help Crobin1. I've amended the script with your suggestion, but unfortunately nothing happens. As soon as the script is started, it stops. There are no error messages and the output file is not created. The amended script is below, have I missed something...
  4. wotsit

    Remote Install Problem

    Hi, I'm hoping somebody could help me please? I need to install some software on all of our servers in a domain (200+), remotely using a script. I put together the vb script below, which successfully installs an msi file on the local computer. For testing purposes, I am using the winzip...
  5. wotsit

    Exporting Results To File

    Hi, I'm having a bit of trouble with a script i'm running. The script successfully queries computers for a list of their installed software and displays the results in the powershell window. I need to be able to write the results to a file instead and i'm a bit stuck on how to, is anybody...
  6. wotsit

    WMI Active Directory Query

    Thank you Geates. I have removed that line, but unfortunately i get the same result. The only thing i get in the .csv file is, 192.168.70.12;; 192.168.70.14;; etc. Is there anything else i've missed?
  7. wotsit

    WMI Active Directory Query

    Thank you all. PHV - I've added the line that you suggested, but it hasn't made any difference. I'm obviously doing something wrong, but can't see what. I'll paste the whole code below, can you see anything obvious? Thank you, H Option Explicit 'On Error Resume Next Dim objFSO, objInFile...
  8. wotsit

    WMI Active Directory Query

    Thank you. I've just tried i but i get the same result. Only this appears in the .csv file: 192.168.70.18;;;; 192.168.70.19;;;; 192.168.70.24;;;; 192.168.70.25;;;; 192.168.70.26;;;; Is there anything else i can try? Thanks.
  9. wotsit

    WMI Active Directory Query

    Thank you for your responding so quickly :) strDS_description is the description field of the computer object in active directory. For example, one severs details should be: DS_description Network Test Server DS_displayName NETTEST01$ DS_memberOf Domain Controllers DS_displayName is...
  10. wotsit

    WMI Active Directory Query

    Hi, I have a wmi query that won't work and i just don't know why. I'm completely stuck and i'm not sure what to do. I am very new to scripting unfortunately and i'm trying to learn. I have a script which runs wmi queries to servers which works successfully. It reads from a text file containing...
  11. wotsit

    Ping / win32_pingstatus and using a text file Query

    That's great, thank you Geates.
  12. wotsit

    vbs script & Unix /linux/oracle

    Hi, I'm wondering if somebody could help me please? I have a working .vbs script that uses a wmi query to retrieve server information, such as name, os, make, model, domain, role etc and write it to a csv or txt file. There are a couple of servers in our network which this script will not run...
  13. wotsit

    Ping / win32_pingstatus and using a text file Query

    Hi, Please forgive me, I'm new to scripting so I haven't got much experience. I have a script which works okay. It queries some ip addresses, then it reports their Asset details in a spreadsheet, like it's make, model, os etc. I have pasted the code at the bottom of this post. I have two...
  14. wotsit

    AD VB Script Query

    That's brilliant, Thank you.
  15. wotsit

    AD VB Script Query

    Hi, I'm new to scripting and I'm a bit stuck, so please forgive me. I've been searching around the internet, but have got myself even more confused. Is there a way to search the local AD and list all of the objects that have a class of computers and then put that information along with what is...
  16. wotsit

    Importing a null value into a spreadsheet

    Hi all. I was wondering if somebody could offer me a bit of advice please as I am a bit stuck and i'm new to macros and vba. I'm importing data into a spreadsheet using a macro that searches a csv file for specific data and then writing the result back to the spreadsheet. It works great...
  17. wotsit

    Importing a csv file to an existing excel spreadsheet

    SkipVought, at the moment there is 470 rows of data but this will grow a fair bit in the future. kjv1611, thank you for your suggestion. It probably does make more sense for it to be held in a database as the spreadsheet will get quite large in size. I will give that a go and see how I get on...
  18. wotsit

    Importing a csv file to an existing excel spreadsheet

    Thank you for your help Combo. I've tried importing the data that way, but it will still just import the data in the order that it is in the csv file, which may not be in the same order within the spreadsheet. Is there any way of getting excel to look in the csv file for the contents of Column...
  19. wotsit

    Importing a csv file to an existing excel spreadsheet

    Hi all. I'm after a bit of help please as i'm a bit stuck. Our server monitoring software kindly produces a csv file containing every server’s name, the size of their disk drives and the amount of disk space that is free. I have created a working spreadsheet which will generate broken down...
  20. wotsit

    Updating an Excel spreadsheet with information from another source

    Hi all. I'm after a bit of help please as i'm a bit stuck due to a limited knowledge of scripting. I am a server engineer and i have been asked by my manager to produce a weekly report on server disk space usage. Our monitoring software kindly produces a printable report and it can also export...

Part and Inventory Search

Back
Top