Search results for query: *

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

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

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

...= GetObject("winmgmts:" & "{impersonationLevel=impersonate}!\\.\root\cimv2") Set objPing = objLocalWMIService.ExecQuery("Select * From Win32_PingStatus Where Address = '" & strComputer & "' and StatusCode=0") IsReachable = objPing.Count > 0 If IsReachable Then ' Check for wmi...

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

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?

...Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\directory\LDAP") Set colItems = objWMIService.ExecQuery("SELECT * FROM ds_computer",,48) For Each objItem In colItems strServerDescription = Join(objItem.DS_description, ",") strServerDescription = objItem.DS_description...

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.

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

...= GetObject("winmgmts:" & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2") Set colItems = objWMIService.ExecQuery("Select * from Win32_ComputerSystem",,48) For Each objItem In colItems StrComputerName= objItem.Caption StrManufacturer = objItem.Manufacturer strModel =...

That's great, thank you Geates.

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

...exists in the spreadsheet Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2") Set colItems = objWMIService.ExecQuery("Select * from Win32_BIOS",,48) For Each objItem In colItems strSerialNumber = "" & objItem.SerialNumber Next Set objWMIService = Nothing Set colItems =...

That's brilliant, Thank you.

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

...and move down to the next cell? I've copied a bit of the code below: Sub Servers() myfile = Application.GetOpenFilename(FileFilter:="CSV Files (*.csv),*.csv") If myfile = False Then ' user clicked CANCEL. get out now. Exit Sub End If...

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

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

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

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