SQL Server Database Restore Utility

Posted on June 11, 2009December 25, 2020 by David

This script is a simple utility to allow users to restore SQL Server databases. It’s easier to use for non-DBAs and it provides a method of restoring databases when the management tools are not installed. It’s a good demonstration of a HTA application, but it’s not a intended as a replacement for SQL Server Management Studio. You can only use this utility for simple restore scenarios.A simple utility that allows you to restore SQL Server databases from a backup file.

<html><head>
<STYLE TYPE="text/css">
	BODY {font-family: "Verdana, Arial, Helvetica, sans-serif";
		font-size:x-small;
		background-color:#dfe0e5;
	}
	
	table {font-family: "Verdana, Arial, Helvetica, sans-serif";
		font-size:x-small;}

	#RestoreCompleted {
		font-weight:bold;
		color:green;
	}

	#RestoreInProgress {
		font-weight:bold;
		color:blue;
	}

	#RestoreError {
		font-weight:bold;
		color:red;
	}
	#Footer {
	font-weight:bold;
	font-size:10px;
}

</STYLE>

<script language="vbscript" OnLoad="Main()">
	option explicit
	Const HKEY_LOCAL_MACHINE = &H80000002
	Const adVarChar = 200
	Const adParamInput = 1 
	Const intAppWidth = 600
	Const intAppHeight = 280 ' 255

	' Set app size and centre screen on load
	Sub Window_Onload()
		Dim objWMIService,objItem,intHorizontal,intVertical
		Dim intLeft, intTop
       	 	Set objWMIService = GetObject("winmgmts:\\.\root\cimv2")
        
       		For Each objItem in objWMIService.ExecQuery("Select * From Win32_DesktopMonitor")
            		intHorizontal = objItem.ScreenWidth
            		intVertical = objItem.ScreenHeight
        	Next
        	If IsNull(intHorizontal) = False And IsNull(intVertical) = False Then
        	        intLeft = (intHorizontal - intAppWidth) / 2
		        	intTop = (intVertical - intAppHeight) / 2
		       	 	window.moveTo intLeft, intTop
       	 	End If
       	 	window.resizeTo intAppWidth,intAppHeight
        	

		LoadSQLServerInstances()
	End Sub
	
	' Populate list box with local SQL Server instances
	Sub LoadSQLServerInstances()
		Dim strComputer,strKeyPath,strValueName,strValue
		Dim oReg,arrValues, d
		
		strComputer = "."

		Set oReg=GetObject("winmgmts:{impersonationLevel=impersonate}!\\" & _ 
		    strComputer & "\root\default:StdRegProv")
		 
		strKeyPath = "SOFTWARE\Microsoft\Microsoft SQL Server\"
		strValueName = "InstalledInstances"
		oReg.GetMultiStringValue HKEY_LOCAL_MACHINE,strKeyPath, _
		    strValueName,arrValues
		If ISArray(arrValues) = false then
			msgbox "No local SQL Server instances found",vbCritical
			Close()
		end If	
		set d = createobject("Scripting.Dictionary")
		For Each strValue In arrValues
			Dim objOption
		    Set objOption = Document.createElement("OPTION")
			if strValue = "LOCAL" OR strValue="MSSQLSERVER" then
				strValue = "(local)"
			else
				strValue = ".\" & strValue
			end if
			objOption.Text = strValue
			objOption.Value = strValue
			
			if d.Exists(strValue) = false then
				if selInstances.Contains(objOption) = false then
					selInstances.Add(objOption)
				end if
				d.Add strValue,strValue
			end if
		Next
	End Sub
	
	' Prompt user to select backup file
	Sub SelectBackupFile()
		Dim oDLG
		Set oDLG=CreateObject("MSComDlg.CommonDialog") 
		With oDLG
			.DialogTitle="Open"
			.Filter="Backup Files|*.bak|All files|*.*"
			.MaxFileSize=255
			.Flags=.Flags Or &H1000	'FileMustExist (OFN_FILEMUSTEXIST)
			.ShowOpen
			If .FileName<>"" Then
				txtFileName.Value =.FileName
			End If
		End With
		Set oDLG=Nothing
	End Sub
	
	' Prompt user for location of database restore
	Sub SelectRestoreFolder()
		Const MY_COMPUTER = &H11&
		Const WINDOW_HANDLE = 0
		Const OPTIONS = 0
		Dim objShell,objFolder,objFolderItem,strPath

		Set objShell = CreateObject("Shell.Application")
		Set objFolder = objShell.Namespace(MY_COMPUTER)
		Set objFolderItem = objFolder.Self
		strPath = objFolderItem.Path

		Set objShell = CreateObject("Shell.Application")
		Set objFolder = objShell.BrowseForFolder _
				(WINDOW_HANDLE, "Select a folder:", OPTIONS, strPath) 
			      
		If not objFolder Is Nothing Then
			Set objFolderItem = objFolder.Self
			txtRestoreFolder.Value = objFolderItem.Path
		End If

	End Sub
	
	' Show/Hide username/password textbox depending on integrated security option
	Sub ShowAuth()
		if chkIntegrated.Checked = true then
			trUserName.Style.Display = "none"
			trPassword.Style.Display = "none"
			window.resizeTo intAppWidth,intAppHeight
		else
			trUserName.Style.Display = "block"
			trPassword.Style.Display = "block"
			window.resizeTo intAppWidth,intAppHeight + 50
		end if
	End Sub
	
	' Generate connection string for the local database
	Private Function GetConnectionString
		Dim strInstance,strUserName,strPassword
		strInstance = selInstances.Value
		strUserName = txtUserName.Value
		strPassword = txtPassword.Value
		if chkIntegrated.Checked = true then
			GetConnectionString = "Provider=SQLOLEDB.1;Data Source=" & strInstance & ";Integrated Security=SSPI;"
		else
			GetConnectionString = "Provider=SQLOLEDB.1;Data Source=" & strInstance & ";UID=" & strUserName & ";PWD=" & strPassword
		end if
	End Function

	' Check if the specified database name already exists
	Function DatabaseExists(byval dbName)
		
		Dim strSQL,objCn,objCmd,strCn, objRs,pName
		strCn = GetConnectionString()
		strSQL = "SELECT COUNT(*) FROM sysdatabases where name = ?"
		set objCn = CREATEOBJECT("ADODB.Connection")
		set objCmd = CREATEOBJECT("ADODB.Command")
		set pName = objCmd.CreateParameter("@name",advarchar,adParamInput,128,dbname)

		objCmd.Parameters.Append pName
		objCn.Open strCn
		objCmd.ActiveConnection = objCn
		objCmd.CommandText = strSQL
		set objRs = objCmd.Execute
		if objRs(0) = 0 then
			DatabaseExists = false
		else
			DatabaseExists = true
		end if
		objRs.Close
		objCn.Close
	end function
	
	' Perform validations before the restore
	Private Function Validate()
		dim objFSO, strCn, objCn,dbName
		set objFSO=createobject("Scripting.FileSystemObject")
		
		' Check backup file exists
		if NOT objFSO.FileExists(txtFileName.Value) then
			RestoreError.InnerHTML = "File specified does not exist"
			Validate = false
			exit function
		end if
		' Check restore folder exists
		if not objFSO.FolderExists(txtRestoreFolder.Value) then
			RestoreError.InnerHTML = "Folder specified does not exist"
			Validate = false
			exit function
		end if
		err.clear
		on error resume next
		' Check connection to database
		strCn = GetConnectionString
		set objCn = CREATEOBJECT("ADODB.Connection")
		objCn.Open strCn
		objCn.Close
		if err.number <> 0 then
			RestoreError.InnerHTML= "Connection error:" & err.number
			Validate = false
			exit function
		end if
		' Get database name from backup file.
		' Just a quick check that backup file is readable
		GetDatabaseNameFromBackupFile()
		if err.number <> 0 then
			RestoreError.InnerHTML = "Error:" & err.number & " - " & err.description
			Validate = false
			exit function
		end if
		on error goto 0
		' Get database name. 
		dbName = GetDatabaseName()
		' Check if database with same name already exists
		if DatabaseExists(dbName) then
			RestoreError.InnerHTML = "Error: Database '" & dbname & "' already exists"
			Validate = false
			exit function	
		end if
	
		Validate = True
	End Function
	
	' Return database name for restore (either from backup file or user specified name)
	Private Function GetDatabaseName
		if chkDBNameDefault.Checked = True then
			GetDatabaseName = GetDatabaseNameFromBackupFile()
		Else
			GetDatabaseName = txtDBName.Value
		end if
	End Function

	' Retreive database name from backup file
	Private Function GetDatabaseNameFromBackupFile
		Dim strSQL,objCn,objCmd,strCn, objRs,pRestoreFile
		strCn = GetConnectionString()
		strSQL = "RESTORE HEADERONLY FROM DISK = ?"
		set objCn = CREATEOBJECT("ADODB.Connection")
		set objCmd = CREATEOBJECT("ADODB.Command")
		set pRestoreFile = objCmd.CreateParameter("@RestoreFile",advarchar,adParamInput,255,txtFileName.Value)

		objCmd.Parameters.Append pRestoreFile
		objCn.Open strCn
		objCmd.ActiveConnection = objCn
		objCmd.CommandText = strSQL
		set objRs = objCmd.Execute
		GetDatabaseNameFromBackupFile = objRs("DatabaseName")
		objCn.Close
	end function

	' Similar to SQL Server QUOTENAME function
	' Wraps quotes around string and performs escapes
	Private Function QuoteName(byval Value, quoteChar)
		if quotechar = "[" or quotechar = "]" then
			QuoteName = "[" & REPLACE(Value,"]","]]") & "]"
		elseif quoteChar = "'" then
			QuoteName = "'" & REPLACE(Value,"'","''") & "'"
		else
			QuoteName = ""
		end if
	End Function
	
	' Function to get the SQL statement used to perform the DB restore
	Private Function GetRestoreSQL
		Dim strSQL,objCn,objCmd,strCn, objRs,pRestoreFile
		Dim dbName
		dbName = GetDatabaseName()
		strCn = GetConnectionString()
		strSQL = "RESTORE FILELISTONLY FROM DISK = ?"
		set objCn = CREATEOBJECT("ADODB.Connection")
		set objCmd = CREATEOBJECT("ADODB.Command")
		set pRestoreFile = objCmd.CreateParameter("@RestoreFile",advarchar,adParamInput,255,txtFileName.Value)

		objCmd.Parameters.Append pRestoreFile
		objCn.Open strCn
		objCmd.ActiveConnection = objCn
		objCmd.CommandText = strSQL
		on error resume next
		set objRs = objCmd.Execute
		if err.number <> 0 then
			msgbox(err.description & err.number)
			exit function
		end if
		
		Dim strFolder
		strFolder = txtRestoreFolder.Value
		if not RIGHT(strFolder,1) = "\" then
			strFolder = strFolder & "\"
		end if
		
		Dim strRestore,strPath
		while objRs.EOF <> True AND objRs.BOF <> True
			strPath = strFolder + dbname & "_" & objRs("LogicalName")
			if objRs("Type") = "L" then 'LOG
				strPath = strPath & ".ldf"
			elseif objRs("Type") = "S" then 'FILESTREAM
				' Folder don't add extension
			else 'DATA
				if objRs("FileID") = "1" then 'Primary File
					strPath = strPath & ".mdf"
				else
					strPath = strPath & ".ndf"
				end if
			end if
			if LEN(strRestore)> 0 then
				strRestore = strRestore & ", " 
			end if
			strRestore = strRestore & "MOVE N" & QuoteName(objRs("LogicalName"),"'") & " TO " & QuoteName(strPath,"'")
			objRs.MoveNext
		wend
		objCn.Close
		
		strRestore = "RESTORE DATABASE " & QuoteName(dbName,"]") & " FROM DISK=N" & QuoteName(txtFileName.Value,"'") & " WITH FILE=1," & strRestore
		
		GetRestoreSQL = strRestore
	End Function
	
	' Perform database restore
	Sub RestoreDatabase()
		Dim strSQL,strCn, objCn, objCmd

		' Clear any existing error/completed notifications
		RestoreError.InnerHTML = ""
		RestoreCompleted.Style.Display = "none"

		' Perform validation checks prior to restore
		if Validate() = false then
			exit sub
		end if
		' Set restore notification
		RestoreInProgress.Style.Display = "block"
		UpdateScreen 

		' Get SQL for Restore
		strSQL = GetRestoreSQL()
		strCn = GetConnectionString()
	
		set objCn = CREATEOBJECT("ADODB.Connection")
		set objCmd = CREATEOBJECT("ADODB.Command")
		objCn.Open strCn
		objCmd.ActiveConnection = objCn
		objCmd.CommandText = strSQL
		objCmd.CommandTimeout = 0
		on error resume next
		objCmd.Execute
		objCn.Close
		if err.number <> 0 then
			RestoreError.InnerHTML = "Error: " & err.Number & " - " & err.description
		else
			RestoreCompleted.Style.Display = "block"
		end if

		RestoreInProgress.Style.Display = "none"
		
	End Sub

	' Causes a refresh
	Sub UpdateScreen() 
		' this is used to allow screen updates 
		dim CMD, WSHShell 
	
		Set WSHShell = CreateObject("WScript.Shell") 
		CMD = WSHShell.ExpandEnvironmentStrings("%comspec%") 
		WSHShell.run CMD + " /c ", 0, true 
		Set WSHShell = Nothing 
	End Sub 

	' Enables/Disables database name textbox 
	Sub DefaultOptionChanged()
		if chkDBNameDefault.Checked = True then
			txtDBName.Disabled = "Disabled"
			txtDBName.style.backgroundcolor = "#dfe0e5"
		else
			txtDBName.Disabled = ""
			txtDBName.style.backgroundcolor = "#ffffff"
		end if
	End Sub
	
</script>
</head>
<HTA:APPLICATION
	APPLICATIONNAME="Restore Database Utility" ID="RestoreDBHTA" INNERBORDER="no" >
<body leftmargin=30 topmargin=20 rightmargin=30>
<table>
<tr>
<td>Backup File:</td><td><input id="txtFileName" style="width=300px;" type="Text" Value=""/><input type="submit" value="Open" OnClick="SelectBackupFile()" /></td>
</tr>
<tr>
<td>Restore Folder:</td><td><input id="txtRestoreFolder" style="width=300px;" type="Text" Value="" /><input type="submit" value="Open" OnClick="SelectRestoreFolder()" /></td>
</tr>
<tr>
<td>SQL Server Instance:</td>
<td>
<select name="selInstances">
</select>
<input id="chkIntegrated" type="checkbox" checked="true" OnClick="ShowAuth()">Integrated Security</input>
</td>
<tr id="trUserName" style="display:none">
<td>UserName:</td><td><input id="txtUserName" style="width=200px;" type="Text" /></td>
</tr>
<tr id="trPassword" style="display:none">
<td>Password</td><td><input id="txtPassword" style="width=200px;" type="password" /></td>
</tr>
<tr>
<td>Database Name:</td><td><input id="txtDBName" style="width=200px;background-color:#dfe0e5" disabled="disabled" type="Text" /><input id="chkDBNameDefault" type="checkbox" checked="true" OnClick="DefaultOptionChanged">Use Default</input></td>
</tr>
</table>
<br/>
<input type="submit" value="Restore Database" OnClick="RestoreDatabase()" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="submit" value="Close" OnClick="Close()" />
<br/>
<span id="RestoreInProgress" style="display:none">Database is been restored - this might take a while depending on the size of the database. Please wait...</span>
<span id="RestoreCompleted" style="display:none">Restore Completed.</span>
<span id="RestoreError"></span>
<div id="Footer">
<hr/>
  <div style="float:left;">Version 1.0</div>
  <div style="float:right;">By David Wiseman<br />
   </div>
    <div style="clear:both;"></div>
    <div style="text-align:center;font-size:12px;font-weight:bold"><a href="http://www.wisesoft.co.uk">www.wisesoft.co.uk</a></div>
</div>

</body></html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

292

293

294

295

296

297

298

299

300

301

302

303

304

305

306

307

308

309

310

311

312

313

314

315

316

317

318

319

320

321

322

323

324

325

326

327

328

329

330

331

332

333

334

335

336

337

338

339

340

341

342

343

344

345

346

347

348

349

350

351

352

353

354

355

356

357

358

359

360

361

362

363

364

365

366

367

368

369

370

371

372

373

374

375

376

377

378

379

380

381

382

383

384

385

386

387

388

389

390

391

392

393

394

395

396

397

398

399

400

401

402

403

404

405

406

407

408

409

410

411

412

413

414

415

416

417

418

419

420

421

422

423

424

425

426

427

428

429

430

431

432

433

434

435

436

437

438

439

BODY {font-family: "Verdana, Arial, Helvetica, sans-serif";

font-size:x-small;

background-color:#dfe0e5;

}

table {font-family: "Verdana, Arial, Helvetica, sans-serif";

font-size:x-small;}

#RestoreCompleted {

font-weight:bold;

color:green;

}

#RestoreInProgress {

font-weight:bold;

color:blue;

}

#RestoreError {

font-weight:bold;

color:red;

}

#Footer {

font-weight:bold;

font-size:10px;

}

</STYLE>

option explicit

Const HKEY_LOCAL_MACHINE = &H80000002

Const adVarChar = 200

Const adParamInput = 1

Const intAppWidth = 600

Const intAppHeight = 280 ' 255

' Set app size and centre screen on load

Sub Window_Onload()

Dim objWMIService,objItem,intHorizontal,intVertical

Dim intLeft, intTop

Set objWMIService = GetObject("winmgmts:\\.\root\cimv2")

For Each objItem in objWMIService.ExecQuery("Select * From Win32_DesktopMonitor")

intHorizontal = objItem.ScreenWidth

intVertical = objItem.ScreenHeight

If IsNull(intHorizontal) = False And IsNull(intVertical) = False Then

intLeft = (intHorizontal - intAppWidth) / 2

intTop = (intVertical - intAppHeight) / 2

window.moveTo intLeft, intTop

End If

window.resizeTo intAppWidth,intAppHeight

LoadSQLServerInstances()

End Sub

' Populate list box with local SQL Server instances

Sub LoadSQLServerInstances()

Dim strComputer,strKeyPath,strValueName,strValue

Dim oReg,arrValues, d

strComputer = "."

Set oReg=GetObject("winmgmts:{impersonationLevel=impersonate}!\\" & _

strComputer & "\root\default:StdRegProv")

strKeyPath = "SOFTWARE\Microsoft\Microsoft SQL Server\"

strValueName = "InstalledInstances"

oReg.GetMultiStringValue HKEY_LOCAL_MACHINE,strKeyPath, _

strValueName,arrValues

If ISArray(arrValues) = false then

msgbox "No local SQL Server instances found",vbCritical

Close()

end If

set d = createobject("Scripting.Dictionary")

For Each strValue In arrValues

Dim objOption

Set objOption = Document.createElement("OPTION")

if strValue = "LOCAL" OR strValue="MSSQLSERVER" then

strValue = "(local)"

else

strValue = ".\" & strValue

end if

objOption.Text = strValue

objOption.Value = strValue

if d.Exists(strValue) = false then

if selInstances.Contains(objOption) = false then

selInstances.Add(objOption)

end if

d.Add strValue,strValue

end if

End Sub

' Prompt user to select backup file

Sub SelectBackupFile()

Dim oDLG

Set oDLG=CreateObject("MSComDlg.CommonDialog")

With oDLG

.DialogTitle="Open"

.Filter="Backup Files|*.bak|All files|*.*"

.MaxFileSize=255

.Flags=.Flags Or &H1000 'FileMustExist (OFN_FILEMUSTEXIST)

.ShowOpen

If .FileName<>"" Then

txtFileName.Value =.FileName

End If

End With

Set oDLG=Nothing

End Sub

' Prompt user for location of database restore

Sub SelectRestoreFolder()

Const MY_COMPUTER = &H11&

Const WINDOW_HANDLE = 0

Const OPTIONS = 0

Dim objShell,objFolder,objFolderItem,strPath

Set objShell = CreateObject("Shell.Application")

Set objFolder = objShell.Namespace(MY_COMPUTER)

Set objFolderItem = objFolder.Self

strPath = objFolderItem.Path

Set objShell = CreateObject("Shell.Application")

Set objFolder = objShell.BrowseForFolder _

(WINDOW_HANDLE, "Select a folder:", OPTIONS, strPath)

If not objFolder Is Nothing Then

Set objFolderItem = objFolder.Self

txtRestoreFolder.Value = objFolderItem.Path

End If

End Sub

' Show/Hide username/password textbox depending on integrated security option

Sub ShowAuth()

if chkIntegrated.Checked = true then

trUserName.Style.Display = "none"

trPassword.Style.Display = "none"

window.resizeTo intAppWidth,intAppHeight

else

trUserName.Style.Display = "block"

trPassword.Style.Display = "block"

window.resizeTo intAppWidth,intAppHeight + 50

end if

End Sub

' Generate connection string for the local database

Private Function GetConnectionString

Dim strInstance,strUserName,strPassword

strInstance = selInstances.Value

strUserName = txtUserName.Value

strPassword = txtPassword.Value

if chkIntegrated.Checked = true then

GetConnectionString = "Provider=SQLOLEDB.1;Data Source=" & strInstance & ";Integrated Security=SSPI;"

else

GetConnectionString = "Provider=SQLOLEDB.1;Data Source=" & strInstance & ";UID=" & strUserName & ";PWD=" & strPassword

end if

End Function

' Check if the specified database name already exists

Function DatabaseExists(byval dbName)

Dim strSQL,objCn,objCmd,strCn, objRs,pName

strCn = GetConnectionString()

strSQL = "SELECT COUNT(*) FROM sysdatabases where name = ?"

set objCn = CREATEOBJECT("ADODB.Connection")

set objCmd = CREATEOBJECT("ADODB.Command")

set pName = objCmd.CreateParameter("@name",advarchar,adParamInput,128,dbname)

objCmd.Parameters.Append pName

objCn.Open strCn

objCmd.ActiveConnection = objCn

objCmd.CommandText = strSQL

set objRs = objCmd.Execute

if objRs(0) = 0 then

DatabaseExists = false

else

DatabaseExists = true

end if

objRs.Close

objCn.Close

end function

' Perform validations before the restore

Private Function Validate()

dim objFSO, strCn, objCn,dbName

set objFSO=createobject("Scripting.FileSystemObject")

' Check backup file exists

if NOT objFSO.FileExists(txtFileName.Value) then

RestoreError.InnerHTML = "File specified does not exist"

Validate = false

exit function

end if

' Check restore folder exists

if not objFSO.FolderExists(txtRestoreFolder.Value) then

RestoreError.InnerHTML = "Folder specified does not exist"

Validate = false

exit function

end if

err.clear

on error resume next

' Check connection to database

strCn = GetConnectionString

set objCn = CREATEOBJECT("ADODB.Connection")

objCn.Open strCn

objCn.Close

if err.number <> 0 then

RestoreError.InnerHTML= "Connection error:" & err.number

Validate = false

exit function

end if

' Get database name from backup file.

' Just a quick check that backup file is readable

GetDatabaseNameFromBackupFile()

if err.number <> 0 then

RestoreError.InnerHTML = "Error:" & err.number & " - " & err.description

Validate = false

exit function

end if

on error goto 0

' Get database name.

dbName = GetDatabaseName()

' Check if database with same name already exists

if DatabaseExists(dbName) then

RestoreError.InnerHTML = "Error: Database '" & dbname & "' already exists"

Validate = false

exit function

end if

Validate = True

End Function

' Return database name for restore (either from backup file or user specified name)

Private Function GetDatabaseName

if chkDBNameDefault.Checked = True then

GetDatabaseName = GetDatabaseNameFromBackupFile()

Else

GetDatabaseName = txtDBName.Value

end if

End Function

' Retreive database name from backup file

Private Function GetDatabaseNameFromBackupFile

Dim strSQL,objCn,objCmd,strCn, objRs,pRestoreFile

strCn = GetConnectionString()

strSQL = "RESTORE HEADERONLY FROM DISK = ?"

set objCn = CREATEOBJECT("ADODB.Connection")

set objCmd = CREATEOBJECT("ADODB.Command")

set pRestoreFile = objCmd.CreateParameter("@RestoreFile",advarchar,adParamInput,255,txtFileName.Value)

objCmd.Parameters.Append pRestoreFile

objCn.Open strCn

objCmd.ActiveConnection = objCn

objCmd.CommandText = strSQL

set objRs = objCmd.Execute

GetDatabaseNameFromBackupFile = objRs("DatabaseName")

objCn.Close

end function

' Similar to SQL Server QUOTENAME function

' Wraps quotes around string and performs escapes

Private Function QuoteName(byval Value, quoteChar)

if quotechar = "[" or quotechar = "]" then

QuoteName = "[" & REPLACE(Value,"]","]]") & "]"

elseif quoteChar = "'" then

QuoteName = "'" & REPLACE(Value,"'","''") & "'"

else

QuoteName = ""

end if

End Function

' Function to get the SQL statement used to perform the DB restore

Private Function GetRestoreSQL

Dim strSQL,objCn,objCmd,strCn, objRs,pRestoreFile

Dim dbName

dbName = GetDatabaseName()

strCn = GetConnectionString()

strSQL = "RESTORE FILELISTONLY FROM DISK = ?"

set objCn = CREATEOBJECT("ADODB.Connection")

set objCmd = CREATEOBJECT("ADODB.Command")

set pRestoreFile = objCmd.CreateParameter("@RestoreFile",advarchar,adParamInput,255,txtFileName.Value)

objCmd.Parameters.Append pRestoreFile

objCn.Open strCn

objCmd.ActiveConnection = objCn

objCmd.CommandText = strSQL

on error resume next

set objRs = objCmd.Execute

if err.number <> 0 then

msgbox(err.description & err.number)

exit function

end if

Dim strFolder

strFolder = txtRestoreFolder.Value

if not RIGHT(strFolder,1) = "\" then

strFolder = strFolder & "\"

end if

Dim strRestore,strPath

while objRs.EOF <> True AND objRs.BOF <> True

strPath = strFolder + dbname & "_" & objRs("LogicalName")

if objRs("Type") = "L" then 'LOG

strPath = strPath & ".ldf"

elseif objRs("Type") = "S" then 'FILESTREAM

' Folder don't add extension

else 'DATA

if objRs("FileID") = "1" then 'Primary File

strPath = strPath & ".mdf"

else

strPath = strPath & ".ndf"

end if

if LEN(strRestore)> 0 then

strRestore = strRestore & ", "

end if

strRestore = strRestore & "MOVE N" & QuoteName(objRs("LogicalName"),"'") & " TO " & QuoteName(strPath,"'")

objRs.MoveNext

wend

objCn.Close

strRestore = "RESTORE DATABASE " & QuoteName(dbName,"]") & " FROM DISK=N" & QuoteName(txtFileName.Value,"'") & " WITH FILE=1," & strRestore

GetRestoreSQL = strRestore

End Function

' Perform database restore

Sub RestoreDatabase()

Dim strSQL,strCn, objCn, objCmd

' Clear any existing error/completed notifications

RestoreError.InnerHTML = ""

RestoreCompleted.Style.Display = "none"

' Perform validation checks prior to restore

if Validate() = false then

exit sub

end if

' Set restore notification

RestoreInProgress.Style.Display = "block"

UpdateScreen

' Get SQL for Restore

strSQL = GetRestoreSQL()

strCn = GetConnectionString()

set objCn = CREATEOBJECT("ADODB.Connection")

set objCmd = CREATEOBJECT("ADODB.Command")

objCn.Open strCn

objCmd.ActiveConnection = objCn

objCmd.CommandText = strSQL

objCmd.CommandTimeout = 0

on error resume next

objCmd.Execute

objCn.Close

if err.number <> 0 then

RestoreError.InnerHTML = "Error: " & err.Number & " - " & err.description

else

RestoreCompleted.Style.Display = "block"

end if

RestoreInProgress.Style.Display = "none"

End Sub

' Causes a refresh

Sub UpdateScreen()

' this is used to allow screen updates

dim CMD, WSHShell

Set WSHShell = CreateObject("WScript.Shell")

CMD = WSHShell.ExpandEnvironmentStrings("%comspec%")

WSHShell.run CMD + " /c ", 0, true

Set WSHShell = Nothing

End Sub

' Enables/Disables database name textbox

Sub DefaultOptionChanged()

if chkDBNameDefault.Checked = True then

txtDBName.Disabled = "Disabled"

txtDBName.style.backgroundcolor = "#dfe0e5"

else

txtDBName.Disabled = ""

txtDBName.style.backgroundcolor = "#ffffff"

end if

End Sub

</script>

</head>

<HTA:APPLICATION

APPLICATIONNAME="Restore Database Utility" ID="RestoreDBHTA" INNERBORDER="no" >

<table>

<tr>

<td>Backup File:</td><td><input id="txtFileName" style="width=300px;" type="Text" Value=""/><input type="submit" value="Open" OnClick="SelectBackupFile()" /></td>

</tr>

<tr>

<td>Restore Folder:</td><td><input id="txtRestoreFolder" style="width=300px;" type="Text" Value="" /><input type="submit" value="Open" OnClick="SelectRestoreFolder()" /></td>

</tr>

<tr>

<td>SQL Server Instance:</td>

<td>

</select>

<input id="chkIntegrated" type="checkbox" checked="true" OnClick="ShowAuth()">Integrated Security</input>

</td>

<td>UserName:</td><td><input id="txtUserName" style="width=200px;" type="Text" /></td>

</tr>

<td>Password</td><td><input id="txtPassword" style="width=200px;" type="password" /></td>

</tr>

<tr>

<td>Database Name:</td><td><input id="txtDBName" style="width=200px;background-color:#dfe0e5" disabled="disabled" type="Text" /><input id="chkDBNameDefault" type="checkbox" checked="true" OnClick="DefaultOptionChanged">Use Default</input></td>

</tr>

</table>

<br/>

<br/>

<span id="RestoreInProgress" style="display:none">Database is been restored - this might take a while depending on the size of the database. Please wait...</span>

<span id="RestoreCompleted" style="display:none">Restore Completed.</span>

<hr/>

<div style="float:left;">Version 1.0</div>

<div style="float:right;">By David Wiseman<br />

</div>

<div style="text-align:center;font-size:12px;font-weight:bold"><a href="http://www.wisesoft.co.uk">www.wisesoft.co.uk</a></div>

</div>

</body></html>

Computer Information Tool – HTA Script

Posted on August 31, 2008May 31, 2020 by David

Collects WMI information about a specified computer and displays a formatted HTML report. Also allows you to monitor and terminate running processes, connect to shares on the remote computer and shutdown/reboot the remote computer.

Don’t be put off by the amount of code – just save the script as a HTA (*.hta) and run. No customization is required, but you are free to modify the script to suite your own purposes.

Features

Display information for local or remote computer. Also, option to connect via alternative credentials.
Reboot/Shutdown computer.
Shortcuts to remote desktop and the computer management MMC console.
Operating System Information
Sortable/Searchable list of running processes
Ability to kill a running process (remotely)
Physical memory information. See how much memory is installed and in which banks.
Logical disk information. Total/Freespace information, including a graphical representation of freespace.
Physical disk information – information on the hard drives installed on the computer. e.g. Manufacturer, Model, Size, Serial etc.
Processor information – information about CPUs installed on the computer.
Shares – Displays a list of all the available shares. Allows you to map shares as drives and connect to shared printers.
Users – Displays a list of local user accounts.
Reset passwords for local users and enable/disable local user accounts.

Version History

Version	Date	Notes
1.1	2009-12-21	Added option to connect with alternative credentials (UserName + Password textboxes added) Added Remote Desktop and Computer Management console shortcut Added menu to shutdown command (additional options now available) Added “Users” section. Displays local user accounts, allows you to reset passwords and enable/disable local user accounts. “Enter” key should now default to “Generate Report” button. Changed report to automatically run for local computer when loaded.
1.0	2008-08-31	Initial release

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Computer Info Tool (http://www.wisesoft.co.uk)</title>
<hta:application applicationname="WiseSoft Computer Info Tool" scroll="yes" singleinstance="no"
        windowstate="normal">
<style type="text/css">
body {
	margin:0px;
	background-color:#CBCBCB; /*#F6F6F6;*/
	font-family:Arial, Helvetica, sans-serif;
	font-size:14px;
	color:#595959;
}
h1 {
	font-size:24px;
	font-weight:bold;
	color:#FFFFFF;
	background-color:#2886C8;
	text-align:center;
	border-style:solid;
	border-width:thin;
	border-color:#C9E0F1;
	padding:5px;
}
h2 {
	font-size:18px;
	font-weight:bold;
}
h3 {
	font-size:16px;
	font-weight:bold;
}
a {
	color:#2886C8;
}

#Main {
	margin-left:20px;
	margin-right:20px;
}
#DisplayError {
	color:red;
	margin-left:20px;
	margin-right:20px;
}
#Footer {
	margin:20px;
	font-weight:bold;
	font-size:16px;
}
#Header {
	margin-left:20px;
	margin-right:20px;
	text-align:center;
}
#Tools {
	text-align:center;
	border-color:#595959;
	border-style:dotted;
	border-width:1px;
	background-color:#F6F6F6;
	margin-left:20px;
	margin-right:20px;
	margin-top:20px;
	padding:5px;
}
.Button { 
	color: #444444; 
} 
.InfoSectionHeader {
	font-size:20px;
	font-weight:bold;
	background-color:#595959;
	color:#FFFFFF;
	text-align:center;
	padding:5px;
	margin-top:0px;
	cursor:pointer;
}
.InfoSection {
	text-align:center;
	margin-bottom:10px;
	background-color:#FFFFFF;
	border-color:#595959;
	border-style:dotted;
	border-width:1px;
}
.InfoSectionBody {
	padding:10px;
}
.Link {
	text-decoration: underline;
	cursor:pointer;
	color:#2886C8;
}
.HeaderLink {
	text-decoration: underline;
	cursor:pointer;
	color:#FFFFFF;
}
.Table {
	/*width:90%;*/
    border: 2px solid;
	border-collapse: collapse;
	border-color: #696969;
}
.Table th {
	border: 1px dotted #111111;
	border-color: #787878;
	color: #FFFFFF;
	font: bold 12pt arial, sans-serif;
	background-color: #595959; /* #787878;*/
	text-align: left;
 padding=3px;
}
.Table td {
	border: 1px dotted #111111;
	border-color: #787878;
	font: bold 10pt arial, sans-serif;
	color: #787878;
 padding=5px;
}

</style>
<script language="VBScript">
	Option Explicit
	Const bytesToMB = 1048576
    Const bytesToGB = 1073741824
    Const bytesToTB = 1099511627776
    Const adVarChar = 200
    Const adDate = 7
	Const MaxCharacters = 255
	Const adFldIsNullable = 32
	Const adInteger = 3
	Const adBigInt = 20
    Const blnConfirmKillProcess = true
	Const ADS_SECURE_AUTHENTICATION = 1
    
    Private objWMIService
    Private strComputer
    private intProcessTimerID
	
	' ***************************************
	' Open Windows explorer to a given path
	' Used when clicking a link in the "Shares" section
	' ***************************************
	Sub OpenUNC(ByVal strPath)
		
		Dim objShell
			
		Set objShell = CreateObject("Wscript.Shell")
		strPath = "explorer.exe /e," & strPath
		objShell.Run strPath

	End Sub
	
	' ***************************************
	' Reboot computer
	' ***************************************
	Sub RebootComputer()
		Dim objItem, colItems
		strComputer = CurrentComputer.InnerHTML
		if MsgBox("Are you sure you want to reboot '" & strComputer & "'?",vbYesNo+vbExclamation,"Confirm Reboot") = vbYes then
			Set colItems = objWMIService.ExecQuery("Select * from Win32_OperatingSystem")
			For Each objItem in colItems
				objItem.Reboot()
			Next
			msgbox "Computer '" & strComputer & "' has been rebooted",vbOKOnly+vbInformation
		end if

	End Sub
	
	' ***************************************
	' Shutdown computer
	' ***************************************
	Sub ShutDownComputer()
		Dim objItem, colItems
		strComputer = CurrentComputer.InnerHTML
		
		dim intOption
		intOption = InputBox("Shutdown computer '" & strComputer & "'" & vbcrlf & _
				"Options:" & vbcrlf & vbcrlf & _
				"0 = Log Off " & vbcrlf & _
				"4 = Forced Log Off" & vbcrlf & _
				"1 = Shut Down" & vbcrlf & _
				"5 = Forced Shutdown" & vbcrlf & _
				"2 = Reboot" & vbcrlf & _
				"6 = Forced Reboot" & vbcrlf & _
				"8 = Power Off" & vbcrlf & _
				"12 = Forced Power Off","Shutdown",1)
		SELECT CASE intOption
			CASE "0","4","1","5","2","6","8","12"
					Set colItems = objWMIService.ExecQuery("Select * from Win32_OperatingSystem")
					For Each objItem in colItems
						objItem.Win32Shutdown(intOption)
					Next
					msgbox "Command has been sent to '" & strComputer & "'",vbOKOnly+vbInformation
			CASE ""
			CASE Else
					msgbox "Invalid option specified:" & intOption,vbOKOnly+vbExclamation
		END SELECT

	End Sub
	
	' ***************************************
	' Kills the specified process
	' Called when "Kill Process" link is clicked in the Running Processes section
	' ***************************************
	Sub KillProcess(ByVal intProcessID, ByVal strName)
		Dim objItem, colItems
		strComputer = CurrentComputer.InnerHTML
		if blnConfirmKillProcess = True then
			if msgbox("Are you sure you want to kill the '" & strName & "' process on '" & strComputer & "'?",vbYesNo+vbExclamation,"Confirm Kill Process") = vbNo then
				exit sub
			end if
		end if
		'Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2")
		Set colItems = objWMIService.ExecQuery("Select * from Win32_Process WHERE ProcessID = '" & _
											 intProcessID & "' AND Name = '" & strName & "'")

		For Each objItem In colItems
			objItem.Terminate()
		Next
		RefreshProcesses
	End Sub
	
	' ***************************************
	' Refreshes list of processes in the "Running Processes" section
	' ***************************************
	Sub RefreshProcesses
		'strComputer = CurrentComputer.InnerHTML
		'Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2")
		ProcessesData.InnerHTML = RunningProcesses_HTML
	End Sub
	
	' ***************************************
	' Enables/Disables the auto refresh feature in the "Running Processes" section
	' ***************************************
	sub SetProcessAutoRefresh
		dim intInterval
		' Get the refresh interval
		intInterval = ProcessAutoRefresh.Value
		' Remove the current auto-refresh
		window.clearInterval(intProcessTimerID)
		' Add an auto-refresh if specified
		if intInterval > 0 then
			intProcessTimerID = window.setInterval("RefreshProcesses", intInterval)
		end if
	end sub
	
	' ***************************************
	' Stores the sort value for "Running Processes" section in a hidden div
	' and refreshes the processes list with the new sort value
	' ***************************************
	Sub SortProcesses(byval strSort)
		' If sort link is clicked twice on the same column, sort descending
		if ProcessSort.InnerHTML = strSort then
			ProcessSort.InnerHTML = strSort & " DESC"
		else
			ProcessSort.InnerHTML = strSort
		end if
		RefreshProcesses()
	End Sub
	
	' ***************************************
	' Map as network drive on this computer to a share on another computer
	' Called from the "Shares" section. User is prompted for a drive letter
	' ***************************************
	Sub MapDrive(ByVal strPath)
		Dim objNetwork
		Dim strDrive
		strDrive = InputBox("Enter drive letter:","Drive Letter","Z")
		If strDrive <> "" Then
			strDrive = Left(strDrive,1) & ":"
		
			Set objNetwork = CreateObject("WScript.Network")
			objNetwork.MapNetworkDrive strDrive,strPath
		End If
	End Sub
	
	' ***************************************
	' Stores the sort value for "Running Processes" section in a hidden div
	' ***************************************
	Sub MapPrinter(ByVal strPath)
		Dim objNetwork
		Set objNetwork = createobject("Wscript.Network")
		objNetwork.AddWindowsPrinterConnection(strPath)
		If MsgBox("Make Printer Default?",vbYesNo+vbQuestion,"Default Printer") = vbYes Then
			objNetwork.SetDefaultPrinter strPath
		End If
	End Sub
	
	' ***************************************
	' Replace special HTML characters
	' ***************************************
	Function HTMLEncode(strValue)
		HTMLEncode= REplace(Replace(strValue,"<","&lt;"),">","&gt;")
	End Function
	
	' ***************************************
	' Convert Bytes to MB,GB or TB as appropriate
	' ***************************************
    Function ConvertToDiskUnit(ByVal value) 
        IF (value/bytesToTb) > 1 Then
            ConvertToDiskUnit = round(value / bytesToTB,1) & " TB"
        ELSEIF (value/bytesToGb) > 1 Then
            ConvertToDiskUnit = round(value / bytesToGB,1) & " GB"
        Else
            ConvertToDiskUnit = round(value / bytesToMB,1) & " MB"
        END If
    End Function
    
    	' ***************************************
	' Convert integer value to string
	' ***************************************
    Function GetMemoryType(ByVal intType)
       	Dim strType
    	Select case intType
    	Case 0
 			strType = "Unknown"
 		Case 1
 			strType = "Other"
 		Case 2
 			strType = "DRAM"
 		Case 3
 			strType = "Synchronous DRAM"
		Case 4
			strType = "Cache DRAM"
		Case 5
			strType = "EDO" 
		Case 6
		 	strType = "EDRAM" 
		Case 7
		 	strType = "VRAM"
		Case 8
		 	strType = "SRAM"
		Case 9
		  	strType = "RAM"
		Case 10
		 	strType = "ROM"
		Case 11
			strType = " Flash"
		Case 12
			strType = "EEPROM"
		Case 13
 			strType = "FEPROM"
		Case 14
		 	strType = " EPROM"
		Case 15
		 	strType = " CDRAM"
		Case 16
		  	strType = "3DRAM"
		Case 17
		 	strType = " SDRAM"
		Case 18
		 	strType = " SGRAM"
		Case 19
		 	strType = " RDRAM"
		Case 20
		 	strType = " DDR"
		Case 21
		 	strType = " DDR-2"
		Case Else
		 	strType = "Unknown"
		End Select
		GetMemoryType=strType
    End Function
    
    ' ***************************************
	' Convert Integer value to string
	' ***************************************
    Function GetMemoryFormFactor(ByVal intFormFactor)
    	Dim strFormFactor
    	Select Case intFormFactor
    	Case 0
			strFormFactor = "Unknown"
		Case 1
			strFormFactor = "Other"
		Case 2
			strFormFactor = "SIP"
		Case 3
			strFormFactor = "DIP"
		Case 4
			strFormFactor = "ZIP"
		Case 5
			strFormFactor = "SOJ"
		Case 6
			strFormFactor = "Proprietary"
		Case 7
			strFormFactor = "SIMM"
		Case 8
			strFormFactor = "DIMM"
		Case 9
			strFormFactor = "TSOP"
		Case 10
			strFormFactor = "PGA"
		Case 11
			strFormFactor = "RIMM"
		Case 12
			strFormFactor = "SODIMM"
		Case 13
			strFormFactor = "SRIMM"
		Case 14
			strFormFactor = "SMD"
		Case 15
			strFormFactor = "SSMP"
		Case 16
			strFormFactor = "QFP"
		Case 17
			strFormFactor = "TQFP"
		Case 18
			strFormFactor = "SOIC"
		Case 19
			strFormFactor = "LCC"
		Case 20
			strFormFactor = "PLCC"
		Case 21
			strFormFactor = "BGA"
		Case 22
			strFormFactor = "FPBGA"
		Case 23
			strFormFactor = "LGA"
		case Else
			strFormFactor = "Unknown"
		End Select
		GetMemoryFormFactor=strFormFactor
    End Function
    
   	' ***************************************
	' Convert date string to a more readable format
	' ***************************************
    Function FormatDate(ByVal strValue)
    	Dim strDate
    	If ISNULL(strValue) Or strValue = "" Then
    		strDate = ""
    	Else
    		strDate = Left(strValue,4) & "-" & MID(strValue,5,2) & "-" & MID(strValue,7,2) & " " & _
    				Mid(strValue,9,2) & ":" &  Mid(strValue,11,2)
    	End If
    	FormatDate = strDate
    End Function
    
	' ***************************************
	' Clear existing report data
	' ***************************************
	Sub Reset
		ProcessAutoRefresh.Value="0"
		window.clearInterval(intProcessTimerID)
		Main.Style.Display = "none"
		Tools.Style.Display = "none"
		LogicalDisk.InnerHTML=""
		PhysicalDisk.InnerHTML=""
		Processor.InnerHTML =""
		Memory.InnerHTML = ""
		OS.InnerHTML =""
		Shares.InnerHTML=""
		DisplayError.InnerHTML=""
	End Sub
	
	' ***************************************
	' Main procedure used to generate report
	' Calls other procedures that generate the HTML for each section
	' ***************************************
	Sub GenerateReport
		Reset()
		strComputer = txtComputer.Value
		if strComputer = "" Then 
			Dim objNetwork
			set objNetwork = createobject("wscript.network")
			strComputer =  objNetwork.ComputerName
			txtComputer.Value = strComputer
		End If
		CurrentComputer.InnerHTML = strComputer
		Dim objSWbemLocator
		On Error Resume Next
		If txtUserName.Value <> "" Then
			Set objSWbemLocator = CreateObject("WbemScripting.SWbemLocator")
			Set objWMIService = objSWbemLocator.ConnectServer _
				(strComputer, "root\cimv2", txtUserName.Value, txtPassword.Value)
			objWMIService.Security_.ImpersonationLevel = 3
		Else
			Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2")
		End If
		
		If Err.Number <> 0 Then
			On Error GoTo 0
			DisplayError.InnerHTML = "Error connecting to '" & strComputer & "'"
			Err.Clear
			Exit Sub
		End If
		On Error GoTo 0
		Main.Style.Display = ""
		Tools.Style.Display = ""
	
		ProcessesData.InnerHTML = RunningProcesses_HTML
		LogicalDisk.InnerHTML = LogicalDisk_HTML
		PhysicalDisk.InnerHTML = PhysicalDisk_HTML
		Processor.InnerHTML = Processor_HTML
		Memory.InnerHTML = Memory_HTML
		OS.InnerHTML = OS_HTML
		Shares.InnerHTML = Shares_HTML
		Users.InnerHTML = Users_HTML
	
	End Sub
	
	
	' ***************************************
	' Gets a list of running processes and returns HTML for the "Running Processes" section
	' ***************************************
	Function RunningProcesses_HTML
		Dim row,strHTML,strFilter
		Dim DataList,colItems,objItem,strUser,strDomain
		Dim strWMIQuery
		strFilter = txtProcessFilter.Value
		
		' Recordset is used to sort data from WMI
		Set DataList = CreateObject("ADOR.Recordset")
		DataList.Fields.Append "Name", adVarChar, MaxCharacters, adFldIsNullable
		DataList.Fields.Append "WorkingSet", adInteger, adFldIsNullable
		DataList.Fields.Append "CreationDate",adVarChar, MaxCharacters, adFldIsNullable
		DataList.Fields.Append "Description",adVarChar,MaxCharacters, adFldIsNullable
		DataList.Fields.Append "ProcessID",adInteger, adFldIsNullable
		DataList.Fields.Append "CPUTime",adInteger, adFldIsNullable
		DataList.Fields.Append "Caption",adVarChar,MaxCharacters, adFldIsNullable
		DataList.Fields.Append "Owner",adVarChar,MaxCharacters, adFldIsNullable
		DataList.Fields.Append "Path",adVarChar,MaxCharacters, adFldIsNullable
		DataList.Open

		strWMIQuery = "Select * From Win32_Process"
		' Add filter if required
		if strFilter <> "" then
			strWMIQuery = strWMIQuery & " WHERE Name LIKE '%" & strFilter & "%'"
		end if
		
		Set colItems = objWMIService.ExecQuery(strWMIQuery)

		' Load WMI data into recordset
		For Each objItem in colItems
			Dim strOwner
    		DataList.AddNew
    		on error resume next
    		DataList("Name") = HTMLEncode(objItem.Name)
    		DataList("WorkingSet") = objItem.WorkingSetSize
    		DataList("CreationDate") = objItem.CreationDate
    		DataList("Description") = HTMLEncode(objItem.Description)
    		DataList("ProcessID") = objItem.ProcessID
    		DataList("Caption") = objItem.Caption
    		DataList("CPUTime") = (CSng(objItem.KernelModeTime) + CSng(objItem.UserModeTime)) / 10000000
    		If objItem.GetOwner (strUser, strDomain) = 0 Then
				strOwner = strDomain & "\" & strUser
			End If
			DataList("Owner") = strOwner
			on error goto 0
    		DataList.Update
		Next
		' Sort recordset
		DataList.Sort = ProcessSort.InnerHTML
		' Check if recordset is not empty
		If DataList.BOF = FALSE then
			DataList.MoveFirst
			' Generate HTML table report with running processes
			strHTML = strHTML & "<table class=""Table"">"
			strHTML = strHTML &  "<tr><th><span onclick=""SortProcesses('Name')"" class=""HeaderLink"">Name</span></th>" & _
						"<th><span onclick=""SortProcesses('CreationDate')"" class=""HeaderLink"">Creation Date</span></th>" & _
						"<th><span onclick=""SortProcesses('Owner')"" class=""HeaderLink"">Owner</span></th>" & _
						"<th><span onclick=""SortProcesses('WorkingSet')"" class=""HeaderLink"">Working Set</span></th>" & _
						"<th><span onclick=""SortProcesses('CPUTime')"" class=""HeaderLink"">Total CPU Time(s)</span></th>" & _
						"<th>&nbsp;</th></tr>"
						
			Do Until DataList.EOF
				Dim strCaption,strCreationDate,strPath,intProcessID,strDescription
				Dim strWorkingSet
								
				strHTML = strHTML & "<tr>" & _
									"<td><div title=""" & DataList("Path") & """>" & DataList("Name") & "</div></td>" & _
									"<td>" & FormatDate(DataList("CreationDate")) & "</td>" & _
									"<td>" & DataList("Owner") & "</td>" & _
									"<td>" & ConvertToDiskUnit(DataList("WorkingSet")) & "</td>" & _
									"<td>" & DataList("CPUTime")  & "</td>" & _
									"<td><span onclick=""KillProcess '" & DataList("ProcessID") & "','" & DataList("Name") & "'"" class=""Link"">Kill Process</span></td>" & _
									"</tr>"
				DataList.MoveNext
			Loop
			strHTML = strHTML & "</table>"
		end if
		DataList.Close
		strHTML = strHTML & "<br>Last Refresh:" & Now()
		
		RunningProcesses_HTML=strHTML
	End Function
	
	' ***************************************
	' Gets a list of shared folders and shared printers and
	' returns HTML for the "Shares" section
	' *************************************** 
    Function Shares_HTML
    	Dim objItem, colItems
		Dim strHTML
		
		' Query to return shared folders
		Set colItems = objWMIService.ExecQuery("Select * from Win32_Share WHERE Type = 2147483648 OR Type = 0")

		strHTML = strHTML & "<table><tr><td style=""vertical-align:top"">"
		strHTML = strHTML & "<table class=""Table""><tr><th colspan=""2"">Folder Shares</th></tr>"
		For Each objItem In colItems
			Dim strShare 
			strShare = HTMLEncode(objItem.Name)
			strHTML = strHTML & "<tr><td><span class=""Link"" onclick=""OpenUNC('\\" & strComputer & "\" & strShare & "')"">" & strShare & "</span></td>"
			strHTML = strHTML &	"<td><input class=""Button"" type=""button"" onclick=""MapDrive('\\" & strComputer & "\" & strShare & "')"" value=""Map Drive""></input></td></tr>"
		Next
		strHTML = strHTML & "</table></td>"
		
		' Query to return shared printers
		Set colItems = objWMIService.ExecQuery("Select * from Win32_Share WHERE Type = 2147483649 OR Type = 1")
		
		strHTML = strHTML & "<td style=""vertical-align:top"">"
		strHTML = strHTML & "<table class=""Table""><tr><th colspan=""2"">Printer Shares</th></tr>"
		For Each objItem In colItems
			Dim strPrinterShare 
			strPrinterShare = HTMLEncode(objItem.Name)
			strHTML = strHTML & "<tr><td><span class=""Link"" onclick=""OpenUNC('\\" & strComputer & "\" & strPrinterShare & "')"">" & strPrinterShare & "</span></td>"
			strHTML = strHTML &	"<td><input class=""Button"" type=""button"" onclick=""MapPrinter('\\" & strComputer & "\" & strPrinterShare & "')"" value=""Connect Printer""></input></td></tr>"
		Next
		strHTML = strHTML & "</table></td></table>"

		Shares_HTML = strHTML 
    End Function
    
    ' ***************************************
	' Gets computer system info to be included in the "OS / General" section
	' *************************************** 
    Sub GetComputerSystemInfo(BYRef strDNSHostName,ByRef strDomain,ByRef strDomainRole, _
    						ByRef strManufacturer,ByRef strModel,ByRef strUserName)
    	Dim objItem, colItems
		
		Set colItems = objWMIService.ExecQuery("Select * from Win32_ComputerSystem")
		For Each objItem In colItems
			On Error Resume Next 
			strDNSHostName = HTMLEncode(objItem.DNSHostName)
			strDomain = HTMLEncode(objItem.Domain)
			strManufacturer = HTMLEncode(objItem.Manufacturer)
			strModel = HTMLEncode(objItem.Model)
			strUserName = HTMLEncode(objItem.UserName)
			On Error GoTo 0
			If strUserName = "" Then
				strUserName = "{not logged in}"
			End If
			Select Case objItem.DomainRole
				Case 0
				strDomainRole="Standalone Workstation"
				Case 1
				strDomainRole="Member Workstation"
				Case 2
				strDomainRole="Standalone Server"
				Case 3
				strDomainRole="Member Server"
				Case 4
				strDomainRole="Backup Domain Controller"
				Case 5
				strDomainRole="Primary Domain Controller"
				Case Else
				strDomainRole = "Unknown (" & strDomainRole & ")"
			End Select
		Next
    End Sub
    
    ' ***************************************
	' Returns a HTML report for the "Operating System/General" section
	' ***************************************  
    Function OS_HTML()
    
    	Dim objItem, colItems
		Dim strHTML
		Dim strDNSHostName,strDomain,strDomainRole,strManufacturer,strModel,strUserName
		GetComputerSystemInfo strDNSHostName,strDomain,strDomainRole,strManufacturer,strModel,strUserName
		
		Set colItems = objWMIService.ExecQuery("Select * from Win32_OperatingSystem")
		
		strHTML = "<h3>Current User: " & strUserName & "</h3>"
		
		For Each objItem In colItems
			Dim strComputerRole
			Dim strCaption,strBuildNumber,strInstallDate,strBootDate
			Dim intServicePackMajor,intServicePackMinor,intTotalVisibleMemorySize
			Dim intFreePhysicalMemory,intTotalVirtualMemorySize,intFreeVirtualMemory
			On Error Resume Next
			strCaption = HTMLEncode(objItem.Caption)
			strBuildNumber = HTMLEncode(objItem.BuildNumber)
			intServicePackMajor = objItem.ServicePackMajorVersion
			intServicePackMinor = objItem.ServicePackMinorVersion
			intTotalVisibleMemorySize = objItem.TotalVisibleMemorySize
			intFreePhysicalMemory = objItem.FreePhysicalMemory
			intFreeVirtualMemory =  objItem.FreeVirtualMemory
			intTotalVirtualMemorySize = objItem.TotalVirtualMemorySize
			strInstallDate = FormatDate(objItem.InstallDate)
			strBootDate = FormatDate(objItem.LastBootUpTime)
			On Error GoTo 0
						
			strHTML = strHTML & "<table class=""Table"">" & _
					 	"<tr>" & _
					 	"<th>Operating System:</th><td>" & strCaption & "</td>" & _
					 	"<th>Build Number:</th><td>" & strBuildNumber & "</td>" & _
					 	"</tr><tr>" & _
					 	"<th>Service Pack:</th><td>" & intServicePackMajor & "." &  intServicePackMinor & "</td>" & _
					 	"<th>Role:</th><td>" & strDomainRole & "</td>" & _
					 	"</tr><tr>" & _
					 	"<th>DNS Host Name:</th><td>" & strDNSHostName & "</td>" & _
					 	"<th>Domain:</th><td>" & strDomain & "</td>" & _
					 	"</tr><tr>" & _
					 	"<th>Manufacturer:</th><td>" & strManufacturer & "</td>" & _
					 	"<th>Model:</th><td>" & strModel & "</td>" & _
					 	"</tr><tr>" & _
					 	"<th>Total Physical Memory:</th><td>" & intTotalVisibleMemorySize & "KB</td>" & _
					 	"<th>Free Physical Memory:</th><td>" & intFreePhysicalMemory  & "KB</td>" & _
					 	"</tr><tr>" & _
					 	"<th>Total Virtual Memory:</th><td>" & intTotalVirtualMemorySize & "KB</td>" & _
					 	"<th>Free Virtual Memory:</th><td>" & intFreeVirtualMemory & "KB</td>" & _
					 	"</tr><tr>" & _
					 	"<th>Install Date:</th><td>" & strInstallDate & "</td>" & _
					 	"<th>Last BootUp Time:</th><td>" & strBootDate & "</td>" & _
					 	"</tr>" & _
					 	"</table>"
					 	
			Exit For
		Next
		
		OS_HTML = strHTML
		
    End Function
    
	' ***************************************
	' Get the number of memory slots and memory arrays
	' for the memory section
	' ***************************************
    Function GetMemoryArrayInfo(ByRef intSlots,ByRef intArrays)
    	Dim objItem, colItems
		intSlots = 0
		intArrays = 0
    	Set colItems = objWMIService.ExecQuery("Select * from Win32_PhysicalMemoryArray WHERE Use=3")
    	
    	For Each objItem In colItems
    		intSlots = intSlots + objItem.MemoryDevices
    		intArrays = intArrays + 1
    	Next
    End Function
    	
	' ***************************************
	' Returns a HTML report for the "Memory" section
	' ***************************************  
	Function Memory_HTML()
    	Dim objItem, colItems
		Dim strHTML
		
		Set colItems = objWMIService.ExecQuery("Select * from Win32_PhysicalMemory")

		strHTML = "<table class=""Table"">" & _
				"<tr>" & _
				"<th>BankLabel</th>" & _
				"<th>Capacity</th>" & _
				"<th>Caption</th>" & _
				"<th>Description</th>" & _
				"<th>DeviceLocator </th>" & _
				"<th>Manufacturer</th>" & _
				"<th>Memory Type</th>" & _
				"<th>Form Factor</th>" & _
				"<th>Model</th>" & _
				"<th>Speed</th>" & _
				"</tr>"

		For Each objItem In colItems
			Dim strBankLabel,strCaption,strDescription,strDeviceLocator
			Dim strManufacturer,strMemoryType,strFormFactor,strModel
			Dim strCapacity,intSpeed
			On Error Resume Next
			strBankLabel = HTMLEncode(objItem.BankLabel) 
			strCapacity = ConvertToDiskUnit(objItem.Capacity)
			strCaption = HTMLEncode(objItem.Caption)
			strDescription = HTMLEncode(objItem.Description)
			strDeviceLocator = HTMLEncode(objItem.DeviceLocator)
			strManufacturer = HTMLEncode(objItem.Manufacturer)
			strMemoryType = GetMemoryType(objItem.MemoryType)
			strFormFactor = GetMemoryFormFactor(objItem.FormFactor)
			strModel = HTMLEncode(objItem.Model)
			intSpeed = objItem.Speed
			On Error GoTo 0
		
			strHTML = strHTML & "<tr><td>" & strBankLabel & "</td>" & _
								"<td>" & strCapacity & "</td>" & _
								"<td>" & strCaption & "</td>" & _
								"<td>" & strDescription & "</td>" & _
								"<td>" & strDeviceLocator & "</td>" & _
								"<td>" & strManufacturer & "</td>" & _
								"<td>" & strMemoryType & "</td>" & _
								"<td>" & strFormFactor & "</td>" & _
								"<td>" & strModel & "</td>" & _
								"<td>" & intSpeed & "</td>" & _
								"</tr>"
		Next
		strHTML = strHTML & "</table>"
		
		Dim intSlots,intArrays
		GetMemoryArrayInfo intSlots,intArrays
		
		strHTML = strHTML & "Total Memory Slots:" & intSlots & ", Memory Arrays:" & intArrays
		
		Memory_HTML=strHTML
    End Function
    
     ' ***************************************
	' Returns a HTML report for the "Processor" section
	' ***************************************  
    Function Processor_HTML()
    	Dim objItem, colItems
		Dim strHTML
		
		Set colItems = objWMIService.ExecQuery("Select * from Win32_Processor")

		strHTML = "<table class=""Table"">" & _
				"<tr>" & _
				"<th>Name</th>" & _
				"<th>Manufacturer</th>" & _
				"<th>Description</th>" & _
				"<th>Address Width</th>" & _
				"<th>Current Clock Speed</th>" & _
				"<th>Data Width</th>" & _
				"<th>Device ID</th>" & _
				"<th>Ext Clock</th>" & _
				"<th>L2 Cache</th>" & _
				"<th>Max Clock Speed</th>" & _
				"<th>#Cores</th>" & _
				"<th>#Logical Processors</th>" & _
				"</tr>"

		For Each objItem in colItems
			Dim strName,strManufacturer,strDescription,strDeviceID
			Dim intAddressWidth,intCurrentClockSpeed,intDataWidth,intExtClock
			Dim intL2CacheSize,intMaxClockSpeed, intNumberOfCores,intNumberOfLogicalProcessors
			On Error Resume Next
			strName = HTMLEncode(objItem.Name)
			strManufacturer = HTMLEncode(objItem.Manufacturer)
			strDescription = HTMLEncode(objItem.Description)
			intAddressWidth = objItem.AddressWidth
			intCurrentClockSpeed = objItem.CurrentClockSpeed
			intDataWidth = objItem.DataWidth
			strDeviceID = HTMLEncode(objItem.DeviceID)
			intExtClock = objItem.ExtClock
			intL2CacheSize = objItem.L2CacheSize
			intMaxClockSpeed = objItem.MaxClockSpeed
			intNumberOfCores  = objItem.NumberOfCores
			intNumberOfLogicalProcessors= objItem.NumberOfLogicalProcessors
			On Error GoTo 0
			strHTML = strHTML & "<tr><td>" & strName & "</td>" & _
								"<td>" & strManufacturer & "</td>" & _
								"<td>" & strDescription & "</td>" & _
								"<td>" & intAddressWidth & "</td>" & _
								"<td>" & intCurrentClockSpeed & "</td>" & _
								"<td>" & intDataWidth & "</td>" & _
								"<td>" & strDeviceID  & "</td>" & _
								"<td>" & intExtClock & "</td>" & _
								"<td>" & intL2CacheSize & "</td>" & _
								"<td>" & intMaxClockSpeed & "</td>" & _
								"<td>" & intNumberOfCores & "</td>" & _
								"<td>" & intNumberOfLogicalProcessors & "</td>" & _
								"</tr>"
		Next
		strHTML = strHTML & "</table>"
		
		Processor_HTML=strHTML
    End Function
    
    ' ***************************************
	' Returns a HTML report for the "Physical Disk" section
	' ***************************************  
    Function PhysicalDisk_HTML()
    	Dim objItem, colItems
		Dim strHTML
		
		Set colItems = objWMIService.ExecQuery("Select * from Win32_DiskDrive")

		strHTML = "<table class=""Table""><tr><th>Caption</th><th>Manufacturer</th>" & _
				"<th>Model</th><th>Size</th><th>Serial</th><th>Media Type</th><th>#Partitions</th><th>DeviceID</th><th>Firmware</th><th>Interface</th></tr>"

		For Each objItem in colItems
			Dim intSize,intPartitions
			Dim strSize,strCaption,strManufacturer,strModel,strMediaType
			Dim strDeviceID,strFirmwareRevision,strInterfaceType, strSerialNumber
			intSize = objItem.Size
			If IsNumeric(intSize) = False Then
				intSize = 0
			End If
			On Error Resume Next
			strCaption= HTMLEncode(objItem.Caption) 
			strSize = ConvertToDiskUnit(intSize)
			strSerialNumber = HTMLEncode(objItem.SerialNumber)
			strMediaType = HTMLEncode(objItem.MediaType)
			intPartitions = HTMLEncode(objItem.Partitions)
			strDeviceID = HTMLEncode(objItem.DeviceID)
			strFirmwareRevision = HTMLEncode(objItem.FirmwareRevision)
			strInterfaceType = HTMLEncode(objItem.InterfaceType)
			strModel = HTMLEncode(objItem.Model)
			strManufacturer = HTMLEncode(objItem.Manufacturer)
			On Error GoTo 0
		
			strHTML = strHTML & "<tr><td>" & strCaption & "</td>" & _
								"<td>" & strManufacturer & "</td>" & _
								"<td>" & strModel & "</td>" & _
								"<td>" & strSize & "</td>" & _
								"<td>" & strSerialNumber & "</td>" & _
								"<td>" & strMediaType & "</td>" & _
								"<td>" & intPartitions & "</td>" & _
								"<td>" & strDeviceID & "</td>" & _
								"<td>" & strFirmwareRevision & "</td>" & _
								"<td>" & strInterfaceType & "</td>" & _
								"</tr>"
		Next
		strHTML = strHTML & "</table>"
		
		PhysicalDisk_HTML=strHTML
    	
    End Function

	' ***************************************
	' Returns a HTML report for the "Logical Disk" section
	' ***************************************  
	Function LogicalDisk_HTML()

		Dim objItem, colItems
		Dim strDriveType, strDiskSize, strHTML
		
		Set colItems = objWMIService.ExecQuery("Select * from Win32_LogicalDisk WHERE DriveType = 3")

		strHTML = "<table class=""Table""><tr><th>Drive</th><th>Name</th><th>File System</th><th>Size</th><th>Used</th><th>Free</th><th>Free(%)</th></tr>"

		For Each objItem in colItems
	
			Dim pctFreeSpace,strFreeSpace,strusedSpace,strName,strFileSystem,strVolumeName
			Dim intFreeSpace, intSize
			On Error Resume Next
			intFreeSpace = objItem.FreeSpace
			intSize = objItem.Size
			If ISNUMERIC(intFreeSpace) = False Then
				intFreeSpace=0
			End If
			If IsNumeric(intSize) = False Then
				intSize = 0
			End If
			If objItem.FreeSpace > 0 Then
				pctFreeSpace = round(((intFreeSpace / intSize) * 100),0)
			Else
				pctFreeSpace=0
			End If
			strDiskSize = ConvertToDiskUnit(intSize) 
			strFreeSpace = ConvertToDiskUnit(intFreeSpace)
			strUsedSpace = ConvertToDiskUnit(intSize-intFreeSpace)
			strName = HTMLEncode(objItem.Name)
			strVolumeName = HTMLEncode(objItem.VolumeName)
			strFileSystem = HTMLEncode(objItem.FileSystem)
			On Error GoTo 0

			dim strChart 
			strChart = "<div width=100%;""><span style=""padding:0px;margin:0px;width=" & 100-pctFreeSpace & _
				"%;background-color:blue;"">&nbsp;</span><span style=""padding:0px;margin:0px;width=" & pctFreeSpace & _
				"%;background-color:#FF00FF;"">&nbsp;</span></div>"

			strHTML = strHTML & "<tr><td>" & strName & "</td><td>" & _
					strVolumeName & "</td><td>" & strFileSystem & "</td><td>" & _
					strDiskSize & "</td><td>" & strUsedSpace & "</td><td>" & _
					strFreeSpace & "</td><td>" &  pctFreeSpace & "%</td></tr>" & _
					"<tr><td colspan=""7"">" & strChart & "</td></tr>"

		Next
	
		strHTML = strHTML + "</table></br>"

		LogicalDisk_HTML = strHTML
	
	End Function
	
	' ***************************************
	' Returns a HTML report for the "Users" section
	' ***************************************  
	Function Users_HTML
		Dim strHTML,colItems,objItem, i, strAccountControl
		Set colItems = objWMIService.ExecQuery("Select * from Win32_UserAccount WHERE LocalAccount=True")
		strHTML = "<table class=""Table""><tr><th>Account Name</th><th>Full Name</th><th>Description</th><th></th><th></th></tr>"
		i = 1
		For Each objItem In colItems
			if objItem.Disabled then
				strAccountControl = "<span id=""AccountControl" & i & """ class=""Link"" OnClick=""ToggleEnableDisable '" & objItem.Name & "','" & strComputer & "','AccountControl" & i & "'"">Enable</span>"
			else
				strAccountControl = "<span id=""AccountControl" & i & """ class=""Link"" OnClick=""ToggleEnableDisable '" & objItem.Name & "','" & strComputer & "','AccountControl" & i & "'"">Disable</span>"
			end if
			strHTML = strHTML & "<tr><td>" & objItem.Name & "</td><td>" & objItem.FullName & "</td><td>" & objItem.Description & _
				"</td><td><input id=""PWD" & i & """ type=""password""></input><span onclick=""ResetPassword '" & objItem.Name & "','" & _
				strComputer & "','PWD" & i & "'"" class=""Link"">Reset Password</span></td><td>" & strAccountControl & "</td></tr>"
			i = i + 1
		next
		strHTML = strHTML & "</table>"
		Users_HTML = strHTML
	End Function
	
	' ***************************************
	' Disables/Enables a user account
	' ***************************************  
	Sub ToggleEnableDisable(strUserName,strComputerName,strID)
		Dim objUser, objNT
		If txtUserName.Value <> "" then
			Set objNT = GetObject("WinNT:")
			Set objUser = objNT.OpenDSObject("WinNT://" & strComputerName & "/" & strUserName & ", user", txtUserName.Value, txtPassword.Value, ADS_SECURE_AUTHENTICATION)
		Else
			Set objUser = GetObject("WinNT://" & strComputerName & "/" & strUserName & ", user")
		End If
		If objUser.AccountDisabled = True Then
			objUser.AccountDisabled = False
			objUser.SetInfo
			document.getElementById(strID).InnerHTML="Disable"
		Else
			objUser.AccountDisabled = True
			objUser.SetInfo
			document.getElementById(strID).InnerHTML="Enable"
		End If
		set objUser = nothing
		set objNT = nothing
	End Sub
	
	' ***************************************
	' Resets a users password
	' ***************************************  
	Sub ResetPassword(strUserName,strComputerName,strPasswordID)
		Dim strPassword, objUser, objNT
		strPassword = document.getElementById(strPasswordID).Value
		If txtUserName.Value <> "" then
			Set objNT = GetObject("WinNT:")
			Set objUser = objNT.OpenDSObject("WinNT://" & strComputerName & "/" & strUserName & ", user", txtUserName.Value, txtPassword.Value, ADS_SECURE_AUTHENTICATION)
		Else
			Set objUser = GetObject("WinNT://" & strComputerName & "/" & strUserName & ", user")
		End If
		objUser.SetPassword strPassword
		set objUser = nothing 
		set objNT = nothing
		msgbox "Password Changed",vbOKOnly+vbInformation,"Computer Info"
	End Sub
	
	' ***************************************
	' Opens Computer Management Console
	' ***************************************  
	Sub ManageComputer
		dim objSh
		set objSh = createobject("wscript.shell")  
		objSh.run "compmgmt.msc /computer:" & strComputer
		set objSh = nothing
	End Sub
	
	' ***************************************
	' Opens a Remote Desktop Connection
	' ***************************************  
	Sub ConnectRDP
		dim objSh
		set objSh = createobject("wscript.shell")  
		objSh.run "mstsc.exe /v:" & strComputer
		set objSh = nothing
	End Sub
	
</script>
<script type="text/javascript">
	/* Toggle expand/collapse state for specified section */
	function toggleDisplay(obj) {
		var el = document.getElementById(obj);
		if ( el.style.display != 'none' ) {
			el.style.display = 'none';
		}
		else {
			el.style.display = '';
		}
	}
	/* Toggle expand/collapse state for all sections */
	function toggleAll() {
		var el = document.getElementById("OS");
		var display = ''
		if ( el.style.display != 'none' ) {
			display = 'none';
		}
		el.style.display = display;
		el = document.getElementById("Memory");
		el.style.display = display;
		el = document.getElementById("LogicalDisk");
		el.style.display = display;
		el = document.getElementById("PhysicalDisk");
		el.style.display = display;
		el = document.getElementById("Processor");
		el.style.display = display;
		el = document.getElementById("Shares");
		el.style.display = display;
		el = document.getElementById("Processes");
		el.style.display = display;
		el = document.getElementById("Users");
		el.style.display = display;
	}

</script>
</head>
<body OnLoad="GenerateReport">
<h1>Computer Info Tool</h1>
<div id="Header" style="padding-bottom:0px;margin-bottom:0px;">
	<table style="font-weight:bold;"><tr><td>UserName:</td><td><input id="txtUserName"></input></td><td style="font-size:8px;">(Optional)</td><tr>
	<tr><td>Password:</td><td><input type="password" id="txtPassword"></input></td><td style="font-size:8px;">(Optional)</td></tr>
	<tr><td>Computer:</td><td><input id="txtComputer"></input></td>
	<td colspan="2">  <input class="Button" style="font-weight:bold;" onClick="GenerateReport()" type="submit" value="Generate Report">
  </input>
  </td></tr>
  </table>
 </div>
 <div id="Tools" style="display:none;margin-bottom:0px;">
   <span class="Link" onClick="RebootComputer">Reboot Computer</span>&nbsp;|&nbsp;
   <span class="Link" onClick="ShutDownComputer">Shutdown Computer</span>&nbsp;|&nbsp;
   <span class="Link" onClick="ConnectRDP">Remote Desktop</span>&nbsp;|&nbsp;
   <span class="Link" onClick="ManageComputer">Manage</span>
  </div>

<div id="Main" style="display:none;">
  <div id="CurrentComputer" style="display:none"></div>
  <div style="text-align:right;">
  <span class="Link" style="font-weight:bold;" onclick="javascript:toggleAll();">Expand/Collapse All</span>
  </div>
  <div class="InfoSection">
    <div onClick="javascript:toggleDisplay('OS');"  class="InfoSectionHeader">Operating System / General</div>
    <div id="OS" class="InfoSectionBody" ></div>
  </div>
  <div class="InfoSection">
    <div onClick="javascript:toggleDisplay('Processes');"  class="InfoSectionHeader">Running Processes</div>
    <div id="Processes" class="InfoSectionBody">
    	Auto Refresh Interval:<select id="ProcessAutoRefresh" onchange="SetProcessAutoRefresh">
		  <option value ="0">None</option>
		  <option value ="1000">1 second</option>
		  <option value ="2000">2 seconds</option>
		  <option value ="3000">3 seconds</option>
		  <option value ="5000">5 seconds</option>
		  <option value ="10000">10 seconds</option>
		  <option value ="20000">20 seconds</option>
		  <option value ="30000">30 seconds</option>
		  <option value ="60000">1 minute</option>
		</select>
		Filter (Optional):<input id="txtProcessFilter"></input>
		<br/><br/>
		<span onclick="RefreshProcesses()" style=""font-weight:bold"" class="Link">Refresh Processes</span>
		<br/><br/>
		
   		<div id="ProcessesData"></div>
    	</div>
    	<div id="ProcessSort" style="display:none">Name</div>
  </div>
  <div class="InfoSection">
    <div onClick="javascript:toggleDisplay('Memory');"  class="InfoSectionHeader">Memory</div>
    <div id="Memory" class="InfoSectionBody"></div>
  </div>
  <div class="InfoSection">
    <div onClick="javascript:toggleDisplay('LogicalDisk');"  class="InfoSectionHeader">Logical Disk</div>
    <div id="LogicalDisk" class="InfoSectionBody"></div>
  </div>
  <div class="InfoSection">
    <div onClick="javascript:toggleDisplay('PhysicalDisk');" class="InfoSectionHeader">Physical Disk</div>
    <div id="PhysicalDisk" class="InfoSectionBody"></div>
  </div>
  <div class="InfoSection">
    <div onClick="javascript:toggleDisplay('Processor');"  class="InfoSectionHeader">Processor</div>
    <div id="Processor" class="InfoSectionBody"></div>
  </div>
  <div class="InfoSection">
    <div onClick="javascript:toggleDisplay('Shares');"  class="InfoSectionHeader">Shares</div>
    <div id="Shares" class="InfoSectionBody"></div>
  </div>
    <div class="InfoSection">
    <div onClick="javascript:toggleDisplay('Users');"  class="InfoSectionHeader">Users</div>
    <div id="Users" class="InfoSectionBody"></div>
  </div>
</div>
<div id="DisplayError"></div>
<div id="Footer">
<hr/>
  <div style="float:left;">Version 1.1</div>
  <div style="float:right;">By David Wiseman<br />
   </div>
    <div style="clear:both;"></div>
    <div style="text-align:center;font-size:20px;font-weight:bold"><a href="http://www.wisesoft.co.uk">www.wisesoft.co.uk</a></div>
</div>
</body>
</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

292

293

294

295

296

297

298

299

300

301

302

303

304

305

306

307

308

309

310

311

312

313

314

315

316

317

318

319

320

321

322

323

324

325

326

327

328

329

330

331

332

333

334

335

336

337

338

339

340

341

342

343

344

345

346

347

348

349

350

351

352

353

354

355

356

357

358

359

360

361

362

363

364

365

366

367

368

369

370

371

372

373

374

375

376

377

378

379

380

381

382

383

384

385

386

387

388

389

390

391

392

393

394

395

396

397

398

399

400

401

402

403

404

405

406

407

408

409

410

411

412

413

414

415

416

417

418

419

420

421

422

423

424

425

426

427

428

429

430

431

432

433

434

435

436

437

438

439

440

441

442

443

444

445

446

447

448

449

450

451

452

453

454

455

456

457

458

459

460

461

462

463

464

465

466

467

468

469

470

471

472

473

474

475

476

477

478

479

480

481

482

483

484

485

486

487

488

489

490

491

492

493

494

495

496

497

498

499

500

501

502

503

504

505

506

507

508

509

510

511

512

513

514

515

516

517

518

519

520

521

522

523

524

525

526

527

528

529

530

531

532

533

534

535

536

537

538

539

540

541

542

543

544

545

546

547

548

549

550

551

552

553

554

555

556

557

558

559

560

561

562

563

564

565

566

567

568

569

570

571

572

573

574

575

576

577

578

579

580

581

582

583

584

585

586

587

588

589

590

591

592

593

594

595

596

597

598

599

600

601

602

603

604

605

606

607

608

609

610

611

612

613

614

615

616

617

618

619

620

621

622

623

624

625

626

627

628

629

630

631

632

633

634

635

636

637

638

639

640

641

642

643

644

645

646

647

648

649

650

651

652

653

654

655

656

657

658

659

660

661

662

663

664

665

666

667

668

669

670

671

672

673

674

675

676

677

678

679

680

681

682

683

684

685

686

687

688

689

690

691

692

693

694

695

696

697

698

699

700

701

702

703

704

705

706

707

708

709

710

711

712

713

714

715

716

717

718

719

720

721

722

723

724

725

726

727

728

729

730

731

732

733

734

735

736

737

738

739

740

741

742

743

744

745

746

747

748

749

750

751

752

753

754

755

756

757

758

759

760

761

762

763

764

765

766

767

768

769

770

771

772

773

774

775

776

777

778

779

780

781

782

783

784

785

786

787

788

789

790

791

792

793

794

795

796

797

798

799

800

801

802

803

804

805

806

807

808

809

810

811

812

813

814

815

816

817

818

819

820

821

822

823

824

825

826

827

828

829

830

831

832

833

834

835

836

837

838

839

840

841

842

843

844

845

846

847

848

849

850

851

852

853

854

855

856

857

858

859

860

861

862

863

864

865

866

867

868

869

870

871

872

873

874

875

876

877

878

879

880

881

882

883

884

885

886

887

888

889

890

891

892

893

894

895

896

897

898

899

900

901

902

903

904

905

906

907

908

909

910

911

912

913

914

915

916

917

918

919

920

921

922

923

924

925

926

927

928

929

930

931

932

933

934

935

936

937

938

939

940

941

942

943

944

945

946

947

948

949

950

951

952

953

954

955

956

957

958

959

960

961

962

963

964

965

966

967

968

969

970

971

972

973

974

975

976

977

978

979

980

981

982

983

984

985

986

987

988

989

990

991

992

993

994

995

996

997

998

999

1000

1001

1002

1003

1004

1005

1006

1007

1008

1009

1010

1011

1012

1013

1014

1015

1016

1017

1018

1019

1020

1021

1022

1023

1024

1025

1026

1027

1028

1029

1030

1031

1032

1033

1034

1035

1036

1037

1038

1039

1040

1041

1042

1043

1044

1045

1046

1047

1048

1049

1050

1051

1052

1053

1054

1055

1056

1057

1058

1059

1060

1061

1062

1063

1064

1065

1066

1067

1068

1069

1070

1071

1072

1073

1074

1075

1076

1077

1078

1079

1080

1081

1082

1083

1084

1085

1086

1087

1088

1089

1090

1091

1092

1093

1094

1095

1096

1097

1098

1099

1100

1101

1102

1103

1104

1105

1106

1107

1108

1109

1110

1111

1112

1113

1114

1115

1116

1117

1118

1119

1120

1121

1122

1123

1124

1125

1126

1127

1128

1129

1130

1131

1132

1133

1134

1135

1136

1137

1138

1139

1140

1141

1142

1143

1144

1145

1146

1147

1148

1149

1150

1151

1152

1153

1154

1155

1156

1157

1158

1159

1160

1161

1162

1163

1164

1165

1166

1167

1168

1169

1170

1171

1172

1173

1174

1175

1176

1177

1178

1179

1180

1181

1182

1183

1184

1185

1186

1187

1188

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<head>

<title>Computer Info Tool (http://www.wisesoft.co.uk)</title>

<hta:application applicationname="WiseSoft Computer Info Tool" scroll="yes" singleinstance="no"

windowstate="normal">

body {

margin:0px;

background-color:#CBCBCB; /*#F6F6F6;*/

font-family:Arial, Helvetica, sans-serif;

font-size:14px;

color:#595959;

}

h1 {

font-size:24px;

font-weight:bold;

color:#FFFFFF;

background-color:#2886C8;

text-align:center;

border-style:solid;

border-width:thin;

border-color:#C9E0F1;

padding:5px;

}

h2 {

font-size:18px;

font-weight:bold;

}

h3 {

font-size:16px;

font-weight:bold;

}

a {

color:#2886C8;

}

#Main {

margin-left:20px;

margin-right:20px;

}

#DisplayError {

color:red;

margin-left:20px;

margin-right:20px;

}

#Footer {

margin:20px;

font-weight:bold;

font-size:16px;

}

#Header {

margin-left:20px;

margin-right:20px;

text-align:center;

}

#Tools {

text-align:center;

border-color:#595959;

border-style:dotted;

border-width:1px;

background-color:#F6F6F6;

margin-left:20px;

margin-right:20px;

margin-top:20px;

padding:5px;

}

.Button {

color: #444444;

}

.InfoSectionHeader {

font-size:20px;

font-weight:bold;

background-color:#595959;

color:#FFFFFF;

text-align:center;

padding:5px;

margin-top:0px;

cursor:pointer;

}

.InfoSection {

text-align:center;

margin-bottom:10px;

background-color:#FFFFFF;

border-color:#595959;

border-style:dotted;

border-width:1px;

}

.InfoSectionBody {

padding:10px;

}

.Link {

text-decoration: underline;

cursor:pointer;

color:#2886C8;

}

.HeaderLink {

text-decoration: underline;

cursor:pointer;

color:#FFFFFF;

}

.Table {

/*width:90%;*/

border: 2px solid;

border-collapse: collapse;

border-color: #696969;

}

.Table th {

border: 1px dotted #111111;

border-color: #787878;

color: #FFFFFF;

font: bold 12pt arial, sans-serif;

background-color: #595959; /* #787878;*/

text-align: left;

padding=3px;

}

.Table td {

border: 1px dotted #111111;

border-color: #787878;

font: bold 10pt arial, sans-serif;

color: #787878;

padding=5px;

}

</style>

Option Explicit

Const bytesToMB = 1048576

Const bytesToGB = 1073741824

Const bytesToTB = 1099511627776

Const adVarChar = 200

Const adDate = 7

Const MaxCharacters = 255

Const adFldIsNullable = 32

Const adInteger = 3

Const adBigInt = 20

Const blnConfirmKillProcess = true

Const ADS_SECURE_AUTHENTICATION = 1

Private objWMIService

Private strComputer

private intProcessTimerID

' ***************************************

' Open Windows explorer to a given path

' Used when clicking a link in the "Shares" section

' ***************************************

Sub OpenUNC(ByVal strPath)

Dim objShell

Set objShell = CreateObject("Wscript.Shell")

strPath = "explorer.exe /e," & strPath

objShell.Run strPath

End Sub

' ***************************************

' Reboot computer

' ***************************************

Sub RebootComputer()

Dim objItem, colItems

strComputer = CurrentComputer.InnerHTML

if MsgBox("Are you sure you want to reboot '" & strComputer & "'?",vbYesNo+vbExclamation,"Confirm Reboot") = vbYes then

Set colItems = objWMIService.ExecQuery("Select * from Win32_OperatingSystem")

For Each objItem in colItems

objItem.Reboot()

msgbox "Computer '" & strComputer & "' has been rebooted",vbOKOnly+vbInformation

end if

End Sub

' ***************************************

' Shutdown computer

' ***************************************

Sub ShutDownComputer()

Dim objItem, colItems

strComputer = CurrentComputer.InnerHTML

dim intOption

intOption = InputBox("Shutdown computer '" & strComputer & "'" & vbcrlf & _

"Options:" & vbcrlf & vbcrlf & _

"0 = Log Off " & vbcrlf & _

"4 = Forced Log Off" & vbcrlf & _

"1 = Shut Down" & vbcrlf & _

"5 = Forced Shutdown" & vbcrlf & _

"2 = Reboot" & vbcrlf & _

"6 = Forced Reboot" & vbcrlf & _

"8 = Power Off" & vbcrlf & _

"12 = Forced Power Off","Shutdown",1)

SELECT CASE intOption

CASE "0","4","1","5","2","6","8","12"

Set colItems = objWMIService.ExecQuery("Select * from Win32_OperatingSystem")

For Each objItem in colItems

objItem.Win32Shutdown(intOption)

msgbox "Command has been sent to '" & strComputer & "'",vbOKOnly+vbInformation

CASE ""

CASE Else

msgbox "Invalid option specified:" & intOption,vbOKOnly+vbExclamation

END SELECT

End Sub

' ***************************************

' Kills the specified process

' Called when "Kill Process" link is clicked in the Running Processes section

' ***************************************

Sub KillProcess(ByVal intProcessID, ByVal strName)

Dim objItem, colItems

strComputer = CurrentComputer.InnerHTML

if blnConfirmKillProcess = True then

if msgbox("Are you sure you want to kill the '" & strName & "' process on '" & strComputer & "'?",vbYesNo+vbExclamation,"Confirm Kill Process") = vbNo then

exit sub

end if

'Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2")

Set colItems = objWMIService.ExecQuery("Select * from Win32_Process WHERE ProcessID = '" & _

intProcessID & "' AND Name = '" & strName & "'")

For Each objItem In colItems

objItem.Terminate()

RefreshProcesses

End Sub

' ***************************************

' Refreshes list of processes in the "Running Processes" section

' ***************************************

Sub RefreshProcesses

'strComputer = CurrentComputer.InnerHTML

'Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2")

ProcessesData.InnerHTML = RunningProcesses_HTML

End Sub

' ***************************************

' Enables/Disables the auto refresh feature in the "Running Processes" section

' ***************************************

sub SetProcessAutoRefresh

dim intInterval

' Get the refresh interval

intInterval = ProcessAutoRefresh.Value

' Remove the current auto-refresh

window.clearInterval(intProcessTimerID)

' Add an auto-refresh if specified

if intInterval > 0 then

intProcessTimerID = window.setInterval("RefreshProcesses", intInterval)

end if

end sub

' ***************************************

' Stores the sort value for "Running Processes" section in a hidden div

' and refreshes the processes list with the new sort value

' ***************************************

Sub SortProcesses(byval strSort)

' If sort link is clicked twice on the same column, sort descending

if ProcessSort.InnerHTML = strSort then

ProcessSort.InnerHTML = strSort & " DESC"

else

ProcessSort.InnerHTML = strSort

end if

RefreshProcesses()

End Sub

' ***************************************

' Map as network drive on this computer to a share on another computer

' Called from the "Shares" section. User is prompted for a drive letter

' ***************************************

Sub MapDrive(ByVal strPath)

Dim objNetwork

Dim strDrive

strDrive = InputBox("Enter drive letter:","Drive Letter","Z")

If strDrive <> "" Then

strDrive = Left(strDrive,1) & ":"

Set objNetwork = CreateObject("WScript.Network")

objNetwork.MapNetworkDrive strDrive,strPath

End If

End Sub

' ***************************************

' Stores the sort value for "Running Processes" section in a hidden div

' ***************************************

Sub MapPrinter(ByVal strPath)

Dim objNetwork

Set objNetwork = createobject("Wscript.Network")

objNetwork.AddWindowsPrinterConnection(strPath)

If MsgBox("Make Printer Default?",vbYesNo+vbQuestion,"Default Printer") = vbYes Then

objNetwork.SetDefaultPrinter strPath

End If

End Sub

' ***************************************

' Replace special HTML characters

' ***************************************

Function HTMLEncode(strValue)

HTMLEncode= REplace(Replace(strValue,"<","<"),">",">")

End Function

' ***************************************

' Convert Bytes to MB,GB or TB as appropriate

' ***************************************

Function ConvertToDiskUnit(ByVal value)

IF (value/bytesToTb) > 1 Then

ConvertToDiskUnit = round(value / bytesToTB,1) & " TB"

ELSEIF (value/bytesToGb) > 1 Then

ConvertToDiskUnit = round(value / bytesToGB,1) & " GB"

Else

ConvertToDiskUnit = round(value / bytesToMB,1) & " MB"

END If

End Function

' ***************************************

' Convert integer value to string

' ***************************************

Function GetMemoryType(ByVal intType)

Dim strType

Select case intType

Case 0

strType = "Unknown"

Case 1

strType = "Other"

Case 2

strType = "DRAM"

Case 3

strType = "Synchronous DRAM"

Case 4

strType = "Cache DRAM"

Case 5

strType = "EDO"

Case 6

strType = "EDRAM"

Case 7

strType = "VRAM"

Case 8

strType = "SRAM"

Case 9

strType = "RAM"

Case 10

strType = "ROM"

Case 11

strType = " Flash"

Case 12

strType = "EEPROM"

Case 13

strType = "FEPROM"

Case 14

strType = " EPROM"

Case 15

strType = " CDRAM"

Case 16

strType = "3DRAM"

Case 17

strType = " SDRAM"

Case 18

strType = " SGRAM"

Case 19

strType = " RDRAM"

Case 20

strType = " DDR"

Case 21

strType = " DDR-2"

Case Else

strType = "Unknown"

End Select

GetMemoryType=strType

End Function

' ***************************************

' Convert Integer value to string

' ***************************************

Function GetMemoryFormFactor(ByVal intFormFactor)

Dim strFormFactor

Select Case intFormFactor

Case 0

strFormFactor = "Unknown"

Case 1

strFormFactor = "Other"

Case 2

strFormFactor = "SIP"

Case 3

strFormFactor = "DIP"

Case 4

strFormFactor = "ZIP"

Case 5

strFormFactor = "SOJ"

Case 6

strFormFactor = "Proprietary"

Case 7

strFormFactor = "SIMM"

Case 8

strFormFactor = "DIMM"

Case 9

strFormFactor = "TSOP"

Case 10

strFormFactor = "PGA"

Case 11

strFormFactor = "RIMM"

Case 12

strFormFactor = "SODIMM"

Case 13

strFormFactor = "SRIMM"

Case 14

strFormFactor = "SMD"

Case 15

strFormFactor = "SSMP"

Case 16

strFormFactor = "QFP"

Case 17

strFormFactor = "TQFP"

Case 18

strFormFactor = "SOIC"

Case 19

strFormFactor = "LCC"

Case 20

strFormFactor = "PLCC"

Case 21

strFormFactor = "BGA"

Case 22

strFormFactor = "FPBGA"

Case 23

strFormFactor = "LGA"

case Else

strFormFactor = "Unknown"

End Select

GetMemoryFormFactor=strFormFactor

End Function

' ***************************************

' Convert date string to a more readable format

' ***************************************

Function FormatDate(ByVal strValue)

Dim strDate

If ISNULL(strValue) Or strValue = "" Then

strDate = ""

Else

strDate = Left(strValue,4) & "-" & MID(strValue,5,2) & "-" & MID(strValue,7,2) & " " & _

Mid(strValue,9,2) & ":" & Mid(strValue,11,2)

End If

FormatDate = strDate

End Function

' ***************************************

' Clear existing report data

' ***************************************

Sub Reset

ProcessAutoRefresh.Value="0"

window.clearInterval(intProcessTimerID)

Main.Style.Display = "none"

Tools.Style.Display = "none"

LogicalDisk.InnerHTML=""

PhysicalDisk.InnerHTML=""

Processor.InnerHTML =""

Memory.InnerHTML = ""

OS.InnerHTML =""

Shares.InnerHTML=""

DisplayError.InnerHTML=""

End Sub

' ***************************************

' Main procedure used to generate report

' Calls other procedures that generate the HTML for each section

' ***************************************

Sub GenerateReport

Reset()

strComputer = txtComputer.Value

if strComputer = "" Then

Dim objNetwork

set objNetwork = createobject("wscript.network")

strComputer = objNetwork.ComputerName

txtComputer.Value = strComputer

End If

CurrentComputer.InnerHTML = strComputer

Dim objSWbemLocator

On Error Resume Next

If txtUserName.Value <> "" Then

Set objSWbemLocator = CreateObject("WbemScripting.SWbemLocator")

Set objWMIService = objSWbemLocator.ConnectServer _

(strComputer, "root\cimv2", txtUserName.Value, txtPassword.Value)

objWMIService.Security_.ImpersonationLevel = 3

Else

Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2")

End If

If Err.Number <> 0 Then

On Error GoTo 0

DisplayError.InnerHTML = "Error connecting to '" & strComputer & "'"

Err.Clear

Exit Sub

End If

On Error GoTo 0

Main.Style.Display = ""

Tools.Style.Display = ""

ProcessesData.InnerHTML = RunningProcesses_HTML

LogicalDisk.InnerHTML = LogicalDisk_HTML

PhysicalDisk.InnerHTML = PhysicalDisk_HTML

Processor.InnerHTML = Processor_HTML

Memory.InnerHTML = Memory_HTML

OS.InnerHTML = OS_HTML

Shares.InnerHTML = Shares_HTML

Users.InnerHTML = Users_HTML

End Sub

' ***************************************

' Gets a list of running processes and returns HTML for the "Running Processes" section

' ***************************************

Function RunningProcesses_HTML

Dim row,strHTML,strFilter

Dim DataList,colItems,objItem,strUser,strDomain

Dim strWMIQuery

strFilter = txtProcessFilter.Value

' Recordset is used to sort data from WMI

Set DataList = CreateObject("ADOR.Recordset")

DataList.Fields.Append "Name", adVarChar, MaxCharacters, adFldIsNullable

DataList.Fields.Append "WorkingSet", adInteger, adFldIsNullable

DataList.Fields.Append "CreationDate",adVarChar, MaxCharacters, adFldIsNullable

DataList.Fields.Append "Description",adVarChar,MaxCharacters, adFldIsNullable

DataList.Fields.Append "ProcessID",adInteger, adFldIsNullable

DataList.Fields.Append "CPUTime",adInteger, adFldIsNullable

DataList.Fields.Append "Caption",adVarChar,MaxCharacters, adFldIsNullable

DataList.Fields.Append "Owner",adVarChar,MaxCharacters, adFldIsNullable

DataList.Fields.Append "Path",adVarChar,MaxCharacters, adFldIsNullable

DataList.Open

strWMIQuery = "Select * From Win32_Process"

' Add filter if required

if strFilter <> "" then

strWMIQuery = strWMIQuery & " WHERE Name LIKE '%" & strFilter & "%'"

end if

Set colItems = objWMIService.ExecQuery(strWMIQuery)

' Load WMI data into recordset

For Each objItem in colItems

Dim strOwner

DataList.AddNew

on error resume next

DataList("Name") = HTMLEncode(objItem.Name)

DataList("WorkingSet") = objItem.WorkingSetSize

DataList("CreationDate") = objItem.CreationDate

DataList("Description") = HTMLEncode(objItem.Description)

DataList("ProcessID") = objItem.ProcessID

DataList("Caption") = objItem.Caption

DataList("CPUTime") = (CSng(objItem.KernelModeTime) + CSng(objItem.UserModeTime)) / 10000000

If objItem.GetOwner (strUser, strDomain) = 0 Then

strOwner = strDomain & "\" & strUser

End If

DataList("Owner") = strOwner

on error goto 0

DataList.Update

' Sort recordset

DataList.Sort = ProcessSort.InnerHTML

' Check if recordset is not empty

If DataList.BOF = FALSE then

DataList.MoveFirst

' Generate HTML table report with running processes

strHTML = strHTML & "<table class=""Table"">"

strHTML = strHTML & "<tr><th><span onclick=""SortProcesses('Name')"" class=""HeaderLink"">Name</span></th>" & _

"<th><span onclick=""SortProcesses('CreationDate')"" class=""HeaderLink"">Creation Date</span></th>" & _

"<th><span onclick=""SortProcesses('Owner')"" class=""HeaderLink"">Owner</span></th>" & _

"<th><span onclick=""SortProcesses('WorkingSet')"" class=""HeaderLink"">Working Set</span></th>" & _

"<th><span onclick=""SortProcesses('CPUTime')"" class=""HeaderLink"">Total CPU Time(s)</span></th>" & _

"<th> </th></tr>"

Do Until DataList.EOF

Dim strCaption,strCreationDate,strPath,intProcessID,strDescription

Dim strWorkingSet

strHTML = strHTML & "<tr>" & _

"<td><div title=""" & DataList("Path") & """>" & DataList("Name") & "</div></td>" & _

"<td>" & FormatDate(DataList("CreationDate")) & "</td>" & _

"<td>" & DataList("Owner") & "</td>" & _

"<td>" & ConvertToDiskUnit(DataList("WorkingSet")) & "</td>" & _

"<td>" & DataList("CPUTime") & "</td>" & _

"<td><span onclick=""KillProcess '" & DataList("ProcessID") & "','" & DataList("Name") & "'"" class=""Link"">Kill Process</span></td>" & _

"</tr>"

DataList.MoveNext

Loop

strHTML = strHTML & "</table>"

end if

DataList.Close

strHTML = strHTML & "<br>Last Refresh:" & Now()

RunningProcesses_HTML=strHTML

End Function

' ***************************************

' Gets a list of shared folders and shared printers and

' returns HTML for the "Shares" section

' ***************************************

Function Shares_HTML

Dim objItem, colItems

Dim strHTML

' Query to return shared folders

Set colItems = objWMIService.ExecQuery("Select * from Win32_Share WHERE Type = 2147483648 OR Type = 0")

strHTML = strHTML & "<table><tr><td style=""vertical-align:top"">"

strHTML = strHTML & "<table class=""Table""><tr><th colspan=""2"">Folder Shares</th></tr>"

For Each objItem In colItems

Dim strShare

strShare = HTMLEncode(objItem.Name)

strHTML = strHTML & "<tr><td><span class=""Link"" onclick=""OpenUNC('\\" & strComputer & "\" & strShare & "')"">" & strShare & "</span></td>"

strHTML = strHTML & "<td><input class=""Button"" type=""button"" onclick=""MapDrive('\\" & strComputer & "\" & strShare & "')"" value=""Map Drive""></input></td></tr>"

strHTML = strHTML & "</table></td>"

' Query to return shared printers

Set colItems = objWMIService.ExecQuery("Select * from Win32_Share WHERE Type = 2147483649 OR Type = 1")

strHTML = strHTML & "<td style=""vertical-align:top"">"

strHTML = strHTML & "<table class=""Table""><tr><th colspan=""2"">Printer Shares</th></tr>"

For Each objItem In colItems

Dim strPrinterShare

strPrinterShare = HTMLEncode(objItem.Name)

strHTML = strHTML & "<tr><td><span class=""Link"" onclick=""OpenUNC('\\" & strComputer & "\" & strPrinterShare & "')"">" & strPrinterShare & "</span></td>"

strHTML = strHTML & "<td><input class=""Button"" type=""button"" onclick=""MapPrinter('\\" & strComputer & "\" & strPrinterShare & "')"" value=""Connect Printer""></input></td></tr>"

strHTML = strHTML & "</table></td></table>"

Shares_HTML = strHTML

End Function

' ***************************************

' Gets computer system info to be included in the "OS / General" section

' ***************************************

Sub GetComputerSystemInfo(BYRef strDNSHostName,ByRef strDomain,ByRef strDomainRole, _

ByRef strManufacturer,ByRef strModel,ByRef strUserName)

Dim objItem, colItems

Set colItems = objWMIService.ExecQuery("Select * from Win32_ComputerSystem")

For Each objItem In colItems

On Error Resume Next

strDNSHostName = HTMLEncode(objItem.DNSHostName)

strDomain = HTMLEncode(objItem.Domain)

strManufacturer = HTMLEncode(objItem.Manufacturer)

strModel = HTMLEncode(objItem.Model)

strUserName = HTMLEncode(objItem.UserName)

On Error GoTo 0

If strUserName = "" Then

strUserName = "{not logged in}"

End If

Select Case objItem.DomainRole

Case 0

strDomainRole="Standalone Workstation"

Case 1

strDomainRole="Member Workstation"

Case 2

strDomainRole="Standalone Server"

Case 3

strDomainRole="Member Server"

Case 4

strDomainRole="Backup Domain Controller"

Case 5

strDomainRole="Primary Domain Controller"

Case Else

strDomainRole = "Unknown (" & strDomainRole & ")"

End Select

End Sub

' ***************************************

' Returns a HTML report for the "Operating System/General" section

' ***************************************

Function OS_HTML()

Dim objItem, colItems

Dim strHTML

Dim strDNSHostName,strDomain,strDomainRole,strManufacturer,strModel,strUserName

GetComputerSystemInfo strDNSHostName,strDomain,strDomainRole,strManufacturer,strModel,strUserName

Set colItems = objWMIService.ExecQuery("Select * from Win32_OperatingSystem")

strHTML = "<h3>Current User: " & strUserName & "</h3>"

For Each objItem In colItems

Dim strComputerRole

Dim strCaption,strBuildNumber,strInstallDate,strBootDate

Dim intServicePackMajor,intServicePackMinor,intTotalVisibleMemorySize

Dim intFreePhysicalMemory,intTotalVirtualMemorySize,intFreeVirtualMemory

On Error Resume Next

strCaption = HTMLEncode(objItem.Caption)

strBuildNumber = HTMLEncode(objItem.BuildNumber)

intServicePackMajor = objItem.ServicePackMajorVersion

intServicePackMinor = objItem.ServicePackMinorVersion

intTotalVisibleMemorySize = objItem.TotalVisibleMemorySize

intFreePhysicalMemory = objItem.FreePhysicalMemory

intFreeVirtualMemory = objItem.FreeVirtualMemory

intTotalVirtualMemorySize = objItem.TotalVirtualMemorySize

strInstallDate = FormatDate(objItem.InstallDate)

strBootDate = FormatDate(objItem.LastBootUpTime)

On Error GoTo 0

strHTML = strHTML & "<table class=""Table"">" & _

"<tr>" & _

"<th>Operating System:</th><td>" & strCaption & "</td>" & _

"<th>Build Number:</th><td>" & strBuildNumber & "</td>" & _

"</tr><tr>" & _

"<th>Service Pack:</th><td>" & intServicePackMajor & "." & intServicePackMinor & "</td>" & _

"<th>Role:</th><td>" & strDomainRole & "</td>" & _

"</tr><tr>" & _

"<th>DNS Host Name:</th><td>" & strDNSHostName & "</td>" & _

"<th>Domain:</th><td>" & strDomain & "</td>" & _

"</tr><tr>" & _

"<th>Manufacturer:</th><td>" & strManufacturer & "</td>" & _

"<th>Model:</th><td>" & strModel & "</td>" & _

"</tr><tr>" & _

"<th>Total Physical Memory:</th><td>" & intTotalVisibleMemorySize & "KB</td>" & _

"<th>Free Physical Memory:</th><td>" & intFreePhysicalMemory & "KB</td>" & _

"</tr><tr>" & _

"<th>Total Virtual Memory:</th><td>" & intTotalVirtualMemorySize & "KB</td>" & _

"<th>Free Virtual Memory:</th><td>" & intFreeVirtualMemory & "KB</td>" & _

"</tr><tr>" & _

"<th>Install Date:</th><td>" & strInstallDate & "</td>" & _

"<th>Last BootUp Time:</th><td>" & strBootDate & "</td>" & _

"</tr>" & _

"</table>"

Exit For

OS_HTML = strHTML

End Function

' ***************************************

' Get the number of memory slots and memory arrays

' for the memory section

' ***************************************

Function GetMemoryArrayInfo(ByRef intSlots,ByRef intArrays)

Dim objItem, colItems

intSlots = 0

intArrays = 0

Set colItems = objWMIService.ExecQuery("Select * from Win32_PhysicalMemoryArray WHERE Use=3")

For Each objItem In colItems

intSlots = intSlots + objItem.MemoryDevices

intArrays = intArrays + 1

End Function

' ***************************************

' Returns a HTML report for the "Memory" section

' ***************************************

Function Memory_HTML()

Dim objItem, colItems

Dim strHTML

Set colItems = objWMIService.ExecQuery("Select * from Win32_PhysicalMemory")

strHTML = "<table class=""Table"">" & _

"<tr>" & _

"<th>BankLabel</th>" & _

"<th>Capacity</th>" & _

"<th>Caption</th>" & _

"<th>Description</th>" & _

"<th>DeviceLocator </th>" & _

"<th>Manufacturer</th>" & _

"<th>Memory Type</th>" & _

"<th>Form Factor</th>" & _

"<th>Model</th>" & _

"<th>Speed</th>" & _

"</tr>"

For Each objItem In colItems

Dim strBankLabel,strCaption,strDescription,strDeviceLocator

Dim strManufacturer,strMemoryType,strFormFactor,strModel

Dim strCapacity,intSpeed

On Error Resume Next

strBankLabel = HTMLEncode(objItem.BankLabel)

strCapacity = ConvertToDiskUnit(objItem.Capacity)

strCaption = HTMLEncode(objItem.Caption)

strDescription = HTMLEncode(objItem.Description)

strDeviceLocator = HTMLEncode(objItem.DeviceLocator)

strManufacturer = HTMLEncode(objItem.Manufacturer)

strMemoryType = GetMemoryType(objItem.MemoryType)

strFormFactor = GetMemoryFormFactor(objItem.FormFactor)

strModel = HTMLEncode(objItem.Model)

intSpeed = objItem.Speed

On Error GoTo 0

strHTML = strHTML & "<tr><td>" & strBankLabel & "</td>" & _

"<td>" & strCapacity & "</td>" & _

"<td>" & strCaption & "</td>" & _

"<td>" & strDescription & "</td>" & _

"<td>" & strDeviceLocator & "</td>" & _

"<td>" & strManufacturer & "</td>" & _

"<td>" & strMemoryType & "</td>" & _

"<td>" & strFormFactor & "</td>" & _

"<td>" & strModel & "</td>" & _

"<td>" & intSpeed & "</td>" & _

"</tr>"

strHTML = strHTML & "</table>"

Dim intSlots,intArrays

GetMemoryArrayInfo intSlots,intArrays

strHTML = strHTML & "Total Memory Slots:" & intSlots & ", Memory Arrays:" & intArrays

Memory_HTML=strHTML

End Function

' ***************************************

' Returns a HTML report for the "Processor" section

' ***************************************

Function Processor_HTML()

Dim objItem, colItems

Dim strHTML

Set colItems = objWMIService.ExecQuery("Select * from Win32_Processor")

strHTML = "<table class=""Table"">" & _

"<tr>" & _

"<th>Name</th>" & _

"<th>Manufacturer</th>" & _

"<th>Description</th>" & _

"<th>Address Width</th>" & _

"<th>Current Clock Speed</th>" & _

"<th>Data Width</th>" & _

"<th>Device ID</th>" & _

"<th>Ext Clock</th>" & _

"<th>L2 Cache</th>" & _

"<th>Max Clock Speed</th>" & _

"<th>#Cores</th>" & _

"<th>#Logical Processors</th>" & _

"</tr>"

For Each objItem in colItems

Dim strName,strManufacturer,strDescription,strDeviceID

Dim intAddressWidth,intCurrentClockSpeed,intDataWidth,intExtClock

Dim intL2CacheSize,intMaxClockSpeed, intNumberOfCores,intNumberOfLogicalProcessors

On Error Resume Next

strName = HTMLEncode(objItem.Name)

strManufacturer = HTMLEncode(objItem.Manufacturer)

strDescription = HTMLEncode(objItem.Description)

intAddressWidth = objItem.AddressWidth

intCurrentClockSpeed = objItem.CurrentClockSpeed

intDataWidth = objItem.DataWidth

strDeviceID = HTMLEncode(objItem.DeviceID)

intExtClock = objItem.ExtClock

intL2CacheSize = objItem.L2CacheSize

intMaxClockSpeed = objItem.MaxClockSpeed

intNumberOfCores = objItem.NumberOfCores

intNumberOfLogicalProcessors= objItem.NumberOfLogicalProcessors

On Error GoTo 0

strHTML = strHTML & "<tr><td>" & strName & "</td>" & _

"<td>" & strManufacturer & "</td>" & _

"<td>" & strDescription & "</td>" & _

"<td>" & intAddressWidth & "</td>" & _

"<td>" & intCurrentClockSpeed & "</td>" & _

"<td>" & intDataWidth & "</td>" & _

"<td>" & strDeviceID & "</td>" & _

"<td>" & intExtClock & "</td>" & _

"<td>" & intL2CacheSize & "</td>" & _

"<td>" & intMaxClockSpeed & "</td>" & _

"<td>" & intNumberOfCores & "</td>" & _

"<td>" & intNumberOfLogicalProcessors & "</td>" & _

"</tr>"

strHTML = strHTML & "</table>"

Processor_HTML=strHTML

End Function

' ***************************************

' Returns a HTML report for the "Physical Disk" section

' ***************************************

Function PhysicalDisk_HTML()

Dim objItem, colItems

Dim strHTML

Set colItems = objWMIService.ExecQuery("Select * from Win32_DiskDrive")

strHTML = "<table class=""Table""><tr><th>Caption</th><th>Manufacturer</th>" & _

"<th>Model</th><th>Size</th><th>Serial</th><th>Media Type</th><th>#Partitions</th><th>DeviceID</th><th>Firmware</th><th>Interface</th></tr>"

For Each objItem in colItems

Dim intSize,intPartitions

Dim strSize,strCaption,strManufacturer,strModel,strMediaType

Dim strDeviceID,strFirmwareRevision,strInterfaceType, strSerialNumber

intSize = objItem.Size

If IsNumeric(intSize) = False Then

intSize = 0

End If

On Error Resume Next

strCaption= HTMLEncode(objItem.Caption)

strSize = ConvertToDiskUnit(intSize)

strSerialNumber = HTMLEncode(objItem.SerialNumber)

strMediaType = HTMLEncode(objItem.MediaType)

intPartitions = HTMLEncode(objItem.Partitions)

strDeviceID = HTMLEncode(objItem.DeviceID)

strFirmwareRevision = HTMLEncode(objItem.FirmwareRevision)

strInterfaceType = HTMLEncode(objItem.InterfaceType)

strModel = HTMLEncode(objItem.Model)

strManufacturer = HTMLEncode(objItem.Manufacturer)

On Error GoTo 0

strHTML = strHTML & "<tr><td>" & strCaption & "</td>" & _

"<td>" & strManufacturer & "</td>" & _

"<td>" & strModel & "</td>" & _

"<td>" & strSize & "</td>" & _

"<td>" & strSerialNumber & "</td>" & _

"<td>" & strMediaType & "</td>" & _

"<td>" & intPartitions & "</td>" & _

"<td>" & strDeviceID & "</td>" & _

"<td>" & strFirmwareRevision & "</td>" & _

"<td>" & strInterfaceType & "</td>" & _

"</tr>"

strHTML = strHTML & "</table>"

PhysicalDisk_HTML=strHTML

End Function

' ***************************************

' Returns a HTML report for the "Logical Disk" section

' ***************************************

Function LogicalDisk_HTML()

Dim objItem, colItems

Dim strDriveType, strDiskSize, strHTML

Set colItems = objWMIService.ExecQuery("Select * from Win32_LogicalDisk WHERE DriveType = 3")

strHTML = "<table class=""Table""><tr><th>Drive</th><th>Name</th><th>File System</th><th>Size</th><th>Used</th><th>Free</th><th>Free(%)</th></tr>"

For Each objItem in colItems

Dim pctFreeSpace,strFreeSpace,strusedSpace,strName,strFileSystem,strVolumeName

Dim intFreeSpace, intSize

On Error Resume Next

intFreeSpace = objItem.FreeSpace

intSize = objItem.Size

If ISNUMERIC(intFreeSpace) = False Then

intFreeSpace=0

End If

If IsNumeric(intSize) = False Then

intSize = 0

End If

If objItem.FreeSpace > 0 Then

pctFreeSpace = round(((intFreeSpace / intSize) * 100),0)

Else

pctFreeSpace=0

End If

strDiskSize = ConvertToDiskUnit(intSize)

strFreeSpace = ConvertToDiskUnit(intFreeSpace)

strUsedSpace = ConvertToDiskUnit(intSize-intFreeSpace)

strName = HTMLEncode(objItem.Name)

strVolumeName = HTMLEncode(objItem.VolumeName)

strFileSystem = HTMLEncode(objItem.FileSystem)

On Error GoTo 0

dim strChart

strChart = "<div width=100%;""><span style=""padding:0px;margin:0px;width=" & 100-pctFreeSpace & _

"%;background-color:blue;""> </span><span style=""padding:0px;margin:0px;width=" & pctFreeSpace & _

"%;background-color:#FF00FF;""> </span></div>"

strHTML = strHTML & "<tr><td>" & strName & "</td><td>" & _

strVolumeName & "</td><td>" & strFileSystem & "</td><td>" & _

strDiskSize & "</td><td>" & strUsedSpace & "</td><td>" & _

strFreeSpace & "</td><td>" & pctFreeSpace & "%</td></tr>" & _

"<tr><td colspan=""7"">" & strChart & "</td></tr>"

strHTML = strHTML + "</table></br>"

LogicalDisk_HTML = strHTML

End Function

' ***************************************

' Returns a HTML report for the "Users" section

' ***************************************

Function Users_HTML

Dim strHTML,colItems,objItem, i, strAccountControl

Set colItems = objWMIService.ExecQuery("Select * from Win32_UserAccount WHERE LocalAccount=True")

strHTML = "<table class=""Table""><tr><th>Account Name</th><th>Full Name</th><th>Description</th><th></th><th></th></tr>"

i = 1

For Each objItem In colItems

if objItem.Disabled then

strAccountControl = "<span id=""AccountControl" & i & """ class=""Link"" OnClick=""ToggleEnableDisable '" & objItem.Name & "','" & strComputer & "','AccountControl" & i & "'"">Enable</span>"

else

strAccountControl = "<span id=""AccountControl" & i & """ class=""Link"" OnClick=""ToggleEnableDisable '" & objItem.Name & "','" & strComputer & "','AccountControl" & i & "'"">Disable</span>"

end if

strHTML = strHTML & "<tr><td>" & objItem.Name & "</td><td>" & objItem.FullName & "</td><td>" & objItem.Description & _

"</td><td><input id=""PWD" & i & """ type=""password""></input><span onclick=""ResetPassword '" & objItem.Name & "','" & _

strComputer & "','PWD" & i & "'"" class=""Link"">Reset Password</span></td><td>" & strAccountControl & "</td></tr>"

i = i + 1

strHTML = strHTML & "</table>"

Users_HTML = strHTML

End Function

' ***************************************

' Disables/Enables a user account

' ***************************************

Sub ToggleEnableDisable(strUserName,strComputerName,strID)

Dim objUser, objNT

If txtUserName.Value <> "" then

Set objNT = GetObject("WinNT:")

Set objUser = objNT.OpenDSObject("WinNT://" & strComputerName & "/" & strUserName & ", user", txtUserName.Value, txtPassword.Value, ADS_SECURE_AUTHENTICATION)

Else

Set objUser = GetObject("WinNT://" & strComputerName & "/" & strUserName & ", user")

End If

If objUser.AccountDisabled = True Then

objUser.AccountDisabled = False

objUser.SetInfo

document.getElementById(strID).InnerHTML="Disable"

Else

objUser.AccountDisabled = True

objUser.SetInfo

document.getElementById(strID).InnerHTML="Enable"

End If

set objUser = nothing

set objNT = nothing

End Sub

' ***************************************

' Resets a users password

' ***************************************

Sub ResetPassword(strUserName,strComputerName,strPasswordID)

Dim strPassword, objUser, objNT

strPassword = document.getElementById(strPasswordID).Value

If txtUserName.Value <> "" then

Set objNT = GetObject("WinNT:")

Set objUser = objNT.OpenDSObject("WinNT://" & strComputerName & "/" & strUserName & ", user", txtUserName.Value, txtPassword.Value, ADS_SECURE_AUTHENTICATION)

Else

Set objUser = GetObject("WinNT://" & strComputerName & "/" & strUserName & ", user")

End If

objUser.SetPassword strPassword

set objUser = nothing

set objNT = nothing

msgbox "Password Changed",vbOKOnly+vbInformation,"Computer Info"

End Sub

' ***************************************

' Opens Computer Management Console

' ***************************************

Sub ManageComputer

dim objSh

set objSh = createobject("wscript.shell")

objSh.run "compmgmt.msc /computer:" & strComputer

set objSh = nothing

End Sub

' ***************************************

' Opens a Remote Desktop Connection

' ***************************************

Sub ConnectRDP

dim objSh

set objSh = createobject("wscript.shell")

objSh.run "mstsc.exe /v:" & strComputer

set objSh = nothing

End Sub

</script>

/* Toggle expand/collapse state for specified section */

function toggleDisplay(obj) {

var el = document.getElementById(obj);

if ( el.style.display != 'none' ) {

el.style.display = 'none';

}

else {

el.style.display = '';

}

/* Toggle expand/collapse state for all sections */

function toggleAll() {

var el = document.getElementById("OS");

var display = ''

if ( el.style.display != 'none' ) {

display = 'none';

}

el.style.display = display;

el = document.getElementById("Memory");

el.style.display = display;

el = document.getElementById("LogicalDisk");

el.style.display = display;

el = document.getElementById("PhysicalDisk");

el.style.display = display;

el = document.getElementById("Processor");

el.style.display = display;

el = document.getElementById("Shares");

el.style.display = display;

el = document.getElementById("Processes");

el.style.display = display;

el = document.getElementById("Users");

el.style.display = display;

}

</script>

</head>

<h1>Computer Info Tool</h1>

<table style="font-weight:bold;"><tr><td>UserName:</td><td><input id="txtUserName"></input></td><td style="font-size:8px;">(Optional)</td><tr>

<tr><td>Password:</td><td><input type="password" id="txtPassword"></input></td><td style="font-size:8px;">(Optional)</td></tr>

<tr><td>Computer:</td><td><input id="txtComputer"></input></td>

</input>

</td></tr>

</table>

</div>

<span class="Link" onClick="RebootComputer">Reboot Computer</span> | 

<span class="Link" onClick="ShutDownComputer">Shutdown Computer</span> | 

<span class="Link" onClick="ConnectRDP">Remote Desktop</span> | 

<span class="Link" onClick="ManageComputer">Manage</span>

</div>

<span class="Link" style="font-weight:bold;" onclick="javascript:toggleAll();">Expand/Collapse All</span>

</div>

<div onClick="javascript:toggleDisplay('OS');" class="InfoSectionHeader">Operating System / General</div>

</div>

<div onClick="javascript:toggleDisplay('Processes');" class="InfoSectionHeader">Running Processes</div>

Auto Refresh Interval:<select id="ProcessAutoRefresh" onchange="SetProcessAutoRefresh">

<option value ="1000">1 second</option>

<option value ="2000">2 seconds</option>

<option value ="3000">3 seconds</option>

<option value ="5000">5 seconds</option>

<option value ="10000">10 seconds</option>

<option value ="20000">20 seconds</option>

<option value ="30000">30 seconds</option>

<option value ="60000">1 minute</option>

</select>

Filter (Optional):<input id="txtProcessFilter"></input>

<span onclick="RefreshProcesses()" style=""font-weight:bold"" class="Link">Refresh Processes</span>

</div>

</div>

<div onClick="javascript:toggleDisplay('Memory');" class="InfoSectionHeader">Memory</div>

</div>

<div onClick="javascript:toggleDisplay('LogicalDisk');" class="InfoSectionHeader">Logical Disk</div>

</div>

<div onClick="javascript:toggleDisplay('PhysicalDisk');" class="InfoSectionHeader">Physical Disk</div>

</div>

<div onClick="javascript:toggleDisplay('Processor');" class="InfoSectionHeader">Processor</div>

</div>

<div onClick="javascript:toggleDisplay('Shares');" class="InfoSectionHeader">Shares</div>

</div>

<div onClick="javascript:toggleDisplay('Users');" class="InfoSectionHeader">Users</div>

</div>

<hr/>

<div style="float:left;">Version 1.1</div>

<div style="float:right;">By David Wiseman<br />

</div>

<div style="text-align:center;font-size:20px;font-weight:bold"><a href="http://www.wisesoft.co.uk">www.wisesoft.co.uk</a></div>

</div>

</body>

</html>

Drive Space Report

Posted on August 3, 2008May 31, 2020 by David

Display a drive space report for multiple computers. This HTA can check the drives of multiple computers and produce a HTML report that will highlight any drives that are low on free space. The HTA also generates a CSV version of the report.

The Drive Space Report is a GUI script that allows you to view the disk drives and free space on several computers. Just enter the computer name or IP Address, one per line and click the “Generate Report” button to display the report. Click the “Download Report (CSV)” button to save the report in CSV (comma separated) format.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<head>
    <title>WiseSoft Drive Space Report</title>
    <hta:application applicationname="WiseSoft Drive Space Report" scroll="yes" singleinstance="yes"
        windowstate="normal">
<style type="text/css">
    body
    {
        background-color: #F2F2F2;
        font: bold 10pt arial,sans-serif;
        color:#787878;
        margin:0px;
    }
    table
    {
        width: 400;
        border: 2px solid;
        border-collapse: collapse;
        border-color: #696969;
    }
    th
    {
        border: 1px dotted #111111;
        border-color: #787878;
        color: #FFFFFF;
        font: bold 12pt arial,sans-serif;
        background-color: #787878;
        text-align: left;
    }
    td
    {
        border: 1px dotted #111111;
        border-color: #787878;
        font: bold 10pt arial,sans-serif;
        color: #787878;
    }
    .neutral
    {
        background-color: #FFFFE0;
        color: #787878;
    }
    .good
    {
        background-color: green;
        color: white;
    }
    .warning
    {
        background-color: yellow;
        color: black;
    }
    .critical
    {
        background-color: red;
        color: black;
    }
    .tableHead td
    {
        padding: 5px;
        font: bold 14pt arial,sans-serif;
        background-color: #787878;
        text-align: center;
        color: white;
    }
    h1
    {
        background-color: #787878;
        color: white;
        font: bold 20pt arial,sans-serif;
        text-align: center;
    }
</style>
</head>

<script language="VBScript">

	OPTION EXPLICIT
    
    ' ********** Constants **********
    CONST bytesToMB = 1048576
    CONST bytesToGB = 1073741824
    CONST bytesToTB = 1099511627776
	CONST warningLevel = 20 ' < 20% = warning (yellow)
	CONST criticalLevel = 10 ' < 10% = critical (red)
	CONST goodLevel = 50 ' > 50% = good (green)
	' **********************************

	SUB GetDriveReportsHTML
		DIM html, strComputer,strComputers
		
		strComputers = txtComputers.value
		
		FOR EACH strComputer in SPLIT(strComputers,CHR(13))
		    strComputer = TRIM(REPLACE(strComputer,CHR(10),""))
		    IF strComputer <> "" THEN
			    html = html & GetDriveReportHTML(strComputer)
			END IF
		NEXT
		report.InnerHTML = html
	END SUB

    FUNCTION ConvertToDiskUnit(BYVAL value) 
        IF (value/bytesToTb) > 1 THEN
            ConvertToDiskUnit = ROUND(value / bytesToTB,1) & " TB"
        ELSEIF (value/bytesToGb) > 1 THEN
            ConvertToDiskUnit = ROUND(value / bytesToGB,1) & " GB"
        ELSE
            ConvertToDiskUnit = ROUND(value / bytesToMB,1) & " MB"
        END IF
    END FUNCTION

	FUNCTION GetDriveReportHTML(BYVAL strComputer)

		DIM objWMIService, objItem, colItems
		DIM strDriveType, strDiskSize, htmlDriveReport

		ON ERROR RESUME NEXT
		SET objWMIService = GETOBJECT("winmgmts:\\" & strComputer & "\root\cimv2")
		IF Err.Number <> 0 THEN
			GetDriveReportHTML = "<span class=""critical"">Error connecting to '" & strComputer & "'</span><br/><br/>"
			Err.Clear
			ON ERROR GOTO 0
			EXIT FUNCTION
		END IF

		ON ERROR GOTO 0
		SET colItems = objWMIService.ExecQuery("Select * from Win32_LogicalDisk WHERE DriveType=3")

		htmlDriveReport = "<table><tr class=""tableHead""><td colspan=""5"">" & strComputer & _
				"</td></tr><tr><th>Drive</th><th>Size</th><th>Used</th><th>Free</th><th>Free(%)</th></tr>"

		FOR EACH objItem in colItems
	
			DIM pctFreeSpace,strFreeSpace,strusedSpace, cssClass
			pctFreeSpace = ROUND(((objItem.FreeSpace / objItem.Size) * 100),1)
			strDiskSize = ConvertToDiskUnit(objItem.Size) 
			strFreeSpace = ConvertToDiskUnit(objItem.FreeSpace)
			strUsedSpace = ConvertToDiskUnit(objItem.Size-objItem.FreeSpace)

			IF pctFreeSpace < criticalLevel THEN
				cssClass = "critical"
			ELSEIF pctFreeSpace < warningLevel THEN
				cssClass = "warning"
			ELSEIF pctFreeSpace > goodLevel THEN
				cssClass = "good"
			ELSE
				cssClass = "neutral"
			END IF

			DIM strChart 
			strChart = "<div style=""width=100%;""><span style=""width=" & 100-pctFreeSpace & _
				"%;background-color:blue;""></span><span style=""width=" & pctFreeSpace & _
				"%;background-color:#FF00FF;""></span></div>"

			htmlDriveReport = htmlDriveReport & "<tr><td>" & objItem.Name & strChart & "</td><td>" & _
					strDiskSize & "</td><td>" & strUsedSpace & "</td><td>" & _
					strFreeSpace & "</td><td class=""" & cssClass & """>" &  pctFreeSpace & "%</td></tr>"

		NEXT
	
		htmlDriveReport = htmlDriveReport + "</table></br>"

		GetDriveReportHTML =  htmlDriveReport
	
	END FUNCTION
	
	SUB GetDriveReportsCSV
	    DIM csv, strComputer,strComputers, path
		
		strComputers = txtComputers.value
		
		csv = "Computer,Drive,Size,Used,Free,Free(%)"
		
		FOR EACH strComputer in SPLIT(strComputers,CHR(13))
		    strComputer = TRIM(REPLACE(strComputer,CHR(10),""))
		    IF strComputer <> "" THEN
		        IF csv <> "" THEN
		            csv = csv & VbCrLf
		        END IF
			    csv = csv & GetDriveReportCSV(strComputer)
			END IF
		NEXT
	    path = INPUTBOX("Enter FileName:","Enter FileName","MyDriveReport.csv")
	    IF path = "" THEN
	        EXIT SUB
	    END IF
	    WriteTextFile csv, path
	 END SUB
	
	FUNCTION GetDriveReportCSV(BYVAL strComputer)

		DIM objWMIService, objItem, colItems
		DIM strDriveType, strDiskSize, csvDriveReport

		ON ERROR RESUME NEXT
		SET objWMIService = GETOBJECT("winmgmts:\\" & strComputer & "\root\cimv2")
		IF Err.Number <> 0 THEN
			GetDriveReportCSV = strComputer & ",Error,Error,Error,Error,Error"
			Err.Clear
			ON ERROR GOTO 0
			EXIT FUNCTION
		END IF

		ON ERROR GOTO 0
		SET colItems = objWMIService.ExecQuery("Select * from Win32_LogicalDisk WHERE DriveType=3")

		FOR EACH objItem in colItems
	
			DIM pctFreeSpace,strFreeSpace,strusedSpace, cssClass
			pctFreeSpace = ROUND(((objItem.FreeSpace / objItem.Size) * 100),1)
			strDiskSize = ConvertToDiskUnit(objItem.Size) 
			strFreeSpace = ConvertToDiskUnit(objItem.FreeSpace)
			strUsedSpace = ConvertToDiskUnit(objItem.Size-objItem.FreeSpace)

			IF pctFreeSpace < criticalLevel THEN
				cssClass = "critical"
			ELSEIF pctFreeSpace < warningLevel THEN
				cssClass = "warning"
			ELSEIF pctFreeSpace > goodLevel THEN
				cssClass = "good"
			ELSE
				cssClass = "neutral"
			END IF
			
			IF csvDriveReport <> "" THEN 
			    csvDriveReport = csvDriveReport & VbCrLf
			END IF

			csvDriveReport = csvDriveReport & strComputer & "," & objItem.Name & "," & _
					strDiskSize & "," & strUsedSpace & "," & _
					strFreeSpace & "," &  pctFreeSpace & "%"

		NEXT
		
		GetDriveReportCSV =  csvDriveReport

	END FUNCTION
	
	SUB WriteTextFile(BYVAL txt,BYVAL path)
	    DIM objFSO, objTextFile
	        
        SET objFSO = CREATEOBJECT("Scripting.FileSystemObject")
        
        IF objFSO.FileExists(path) THEN
            IF MSGBOX("Warning: file already exists! Overwrite file?",vbYesNo+vbQuestion,"Overwrite File?") = vbNo THEN
                EXIT SUB
            END IF
        END IF

        SET objTextFile = objFSO.CreateTextFile(path)

        objTextFile.Write(txt)
        objTextFile.Close
        MSGBOX "Created '" & path & "' Report",vbOKOnly+vbInformation
	END SUB

</script>

<body>
    <h1 style="margin-bottom: 0px;">
        Drive Space Report</h1>
    <div style="text-align: right; font: bold 8pt arial,sans-serif; color: #787878;">
        By David Wiseman, <a target="_blank" href="http://www.wisesoft.co.uk">www.wisesoft.co.uk</a>
     </div><br />
    <div style="text-align: center;">
Enter names of computers (one line per computer):<br />
        <textarea name="txtComputers" rows="4" cols="50">
localhost
.
127.0.0.1
        </textarea><br />
        <input style="font-weight:bold;" onclick="GetDriveReportsHTML" type="submit" value="Generate Report"></input> 
        <input onclick="GetDriveReportsCSV" type="submit" value="Download Report (CSV)"></input>
        <br />
        <br />
    </div>
    <div style="text-align: center;" id="report">
    </div>
</body>
</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<head>

<title>WiseSoft Drive Space Report</title>

<hta:application applicationname="WiseSoft Drive Space Report" scroll="yes" singleinstance="yes"

windowstate="normal">

body

{

background-color: #F2F2F2;

font: bold 10pt arial,sans-serif;

color:#787878;

margin:0px;

}

table

{

width: 400;

border: 2px solid;

border-collapse: collapse;

border-color: #696969;

}

{

border: 1px dotted #111111;

border-color: #787878;

color: #FFFFFF;

font: bold 12pt arial,sans-serif;

background-color: #787878;

text-align: left;

}

{

border: 1px dotted #111111;

border-color: #787878;

font: bold 10pt arial,sans-serif;

color: #787878;

}

.neutral

{

background-color: #FFFFE0;

color: #787878;

}

.good

{

background-color: green;

color: white;

}

.warning

{

background-color: yellow;

color: black;

}

.critical

{

background-color: red;

color: black;

}

.tableHead td

{

padding: 5px;

font: bold 14pt arial,sans-serif;

background-color: #787878;

text-align: center;

color: white;

}

{

background-color: #787878;

color: white;

font: bold 20pt arial,sans-serif;

text-align: center;

}

</style>

</head>

OPTION EXPLICIT

' ********** Constants **********

CONST bytesToMB = 1048576

CONST bytesToGB = 1073741824

CONST bytesToTB = 1099511627776

CONST warningLevel = 20 ' < 20% = warning (yellow)

CONST criticalLevel = 10 ' < 10% = critical (red)

CONST goodLevel = 50 ' > 50% = good (green)

' **********************************

SUB GetDriveReportsHTML

DIM html, strComputer,strComputers

strComputers = txtComputers.value

FOR EACH strComputer in SPLIT(strComputers,CHR(13))

strComputer = TRIM(REPLACE(strComputer,CHR(10),""))

IF strComputer <> "" THEN

html = html & GetDriveReportHTML(strComputer)

END IF

report.InnerHTML = html

END SUB

FUNCTION ConvertToDiskUnit(BYVAL value)

IF (value/bytesToTb) > 1 THEN

ConvertToDiskUnit = ROUND(value / bytesToTB,1) & " TB"

ELSEIF (value/bytesToGb) > 1 THEN

ConvertToDiskUnit = ROUND(value / bytesToGB,1) & " GB"

ELSE

ConvertToDiskUnit = ROUND(value / bytesToMB,1) & " MB"

END IF

END FUNCTION

FUNCTION GetDriveReportHTML(BYVAL strComputer)

DIM objWMIService, objItem, colItems

DIM strDriveType, strDiskSize, htmlDriveReport

ON ERROR RESUME NEXT

SET objWMIService = GETOBJECT("winmgmts:\\" & strComputer & "\root\cimv2")

IF Err.Number <> 0 THEN

GetDriveReportHTML = "<span class=""critical"">Error connecting to '" & strComputer & "'</span><br/><br/>"

Err.Clear

ON ERROR GOTO 0

EXIT FUNCTION

END IF

ON ERROR GOTO 0

SET colItems = objWMIService.ExecQuery("Select * from Win32_LogicalDisk WHERE DriveType=3")

htmlDriveReport = "<table><tr class=""tableHead""><td colspan=""5"">" & strComputer & _

"</td></tr><tr><th>Drive</th><th>Size</th><th>Used</th><th>Free</th><th>Free(%)</th></tr>"

FOR EACH objItem in colItems

DIM pctFreeSpace,strFreeSpace,strusedSpace, cssClass

pctFreeSpace = ROUND(((objItem.FreeSpace / objItem.Size) * 100),1)

strDiskSize = ConvertToDiskUnit(objItem.Size)

strFreeSpace = ConvertToDiskUnit(objItem.FreeSpace)

strUsedSpace = ConvertToDiskUnit(objItem.Size-objItem.FreeSpace)

IF pctFreeSpace < criticalLevel THEN

cssClass = "critical"

ELSEIF pctFreeSpace < warningLevel THEN

cssClass = "warning"

ELSEIF pctFreeSpace > goodLevel THEN

cssClass = "good"

ELSE

cssClass = "neutral"

END IF

DIM strChart

strChart = "<div style=""width=100%;""><span style=""width=" & 100-pctFreeSpace & _

"%;background-color:blue;""></span><span style=""width=" & pctFreeSpace & _

"%;background-color:#FF00FF;""></span></div>"

htmlDriveReport = htmlDriveReport & "<tr><td>" & objItem.Name & strChart & "</td><td>" & _

strDiskSize & "</td><td>" & strUsedSpace & "</td><td>" & _

strFreeSpace & "</td><td class=""" & cssClass & """>" & pctFreeSpace & "%</td></tr>"

htmlDriveReport = htmlDriveReport + "</table></br>"

GetDriveReportHTML = htmlDriveReport

END FUNCTION

SUB GetDriveReportsCSV

DIM csv, strComputer,strComputers, path

strComputers = txtComputers.value

csv = "Computer,Drive,Size,Used,Free,Free(%)"

FOR EACH strComputer in SPLIT(strComputers,CHR(13))

strComputer = TRIM(REPLACE(strComputer,CHR(10),""))

IF strComputer <> "" THEN

IF csv <> "" THEN

csv = csv & VbCrLf

END IF

csv = csv & GetDriveReportCSV(strComputer)

END IF

path = INPUTBOX("Enter FileName:","Enter FileName","MyDriveReport.csv")

IF path = "" THEN

EXIT SUB

END IF

WriteTextFile csv, path

END SUB

FUNCTION GetDriveReportCSV(BYVAL strComputer)

DIM objWMIService, objItem, colItems

DIM strDriveType, strDiskSize, csvDriveReport

ON ERROR RESUME NEXT

SET objWMIService = GETOBJECT("winmgmts:\\" & strComputer & "\root\cimv2")

IF Err.Number <> 0 THEN

GetDriveReportCSV = strComputer & ",Error,Error,Error,Error,Error"

Err.Clear

ON ERROR GOTO 0

EXIT FUNCTION

END IF

ON ERROR GOTO 0

SET colItems = objWMIService.ExecQuery("Select * from Win32_LogicalDisk WHERE DriveType=3")

FOR EACH objItem in colItems

DIM pctFreeSpace,strFreeSpace,strusedSpace, cssClass

pctFreeSpace = ROUND(((objItem.FreeSpace / objItem.Size) * 100),1)

strDiskSize = ConvertToDiskUnit(objItem.Size)

strFreeSpace = ConvertToDiskUnit(objItem.FreeSpace)

strUsedSpace = ConvertToDiskUnit(objItem.Size-objItem.FreeSpace)

IF pctFreeSpace < criticalLevel THEN

cssClass = "critical"

ELSEIF pctFreeSpace < warningLevel THEN

cssClass = "warning"

ELSEIF pctFreeSpace > goodLevel THEN

cssClass = "good"

ELSE

cssClass = "neutral"

END IF

IF csvDriveReport <> "" THEN

csvDriveReport = csvDriveReport & VbCrLf

END IF

csvDriveReport = csvDriveReport & strComputer & "," & objItem.Name & "," & _

strDiskSize & "," & strUsedSpace & "," & _

strFreeSpace & "," & pctFreeSpace & "%"

GetDriveReportCSV = csvDriveReport

END FUNCTION

SUB WriteTextFile(BYVAL txt,BYVAL path)

DIM objFSO, objTextFile

SET objFSO = CREATEOBJECT("Scripting.FileSystemObject")

IF objFSO.FileExists(path) THEN

IF MSGBOX("Warning: file already exists! Overwrite file?",vbYesNo+vbQuestion,"Overwrite File?") = vbNo THEN

EXIT SUB

END IF

SET objTextFile = objFSO.CreateTextFile(path)

objTextFile.Write(txt)

objTextFile.Close

MSGBOX "Created '" & path & "' Report",vbOKOnly+vbInformation

END SUB

</script>

<body>

Drive Space Report</h1>

By David Wiseman, <a target="_blank" href="http://www.wisesoft.co.uk">www.wisesoft.co.uk</a>

</div><br />

Enter names of computers (one line per computer):<br />

localhost

127.0.0.1

</textarea><br />

<br />

</div>

</div>

</body>

</html>