No problem. Actually, perhaps you can look over my script, but it's not printing everything correctly.
The mac address field is printing up as "%B-%C-%D-%E-%F-%G"
and the wmic commands aren't coming out. The categories aren't printing either errr.
Here is the script
PHP Code:
@echo off
::------------------------
:: Global Variables
::------------------------
setlocal enabledelayedexpansion
set lineA = 1
set lineB = 1
set lineC = 1
set computername = hostname
set date = date /t
set time = time /t
set stringcat = name
set stringcat = %stringcat%,User Name
set stringcat = %stringcat%,Device Name
set stringcat = %stringcat%,Serial Number
set stringcat = %stringcat%,Computer Model
set stringcat = %stringcat%,Deploy Date
set stringcat = %stringcat%,Wired Mac Address
set stringcat = %stringcat%,Wired Mac Address
set stringval=%name%
::------------------------
:: User Name
::------------------------
::set stringval = %stringval%,%username%
echo Username,%username% >> \\earth\tablets\james\Test.csv
::------------------------
:: Device Name
::------------------------
::set stringval = %stringval%,%computername%
echo Computer Name,%computername% >> \\earth\tablets\james\Test.csv
::------------------------
:: Get Serial Number
::------------------------
for /f "delims=" %%A in ('wmic bios get serialnumber') do (
if !lineA! equ 2 set serialNumber=%%A
set /a lineA+=1)
::set stringval = %stringval%,%serialNumber%
echo Serial Number,%serialNumber% >> \\earth\tablets\james\Test.csv
::------------------------
:: Get Model
::------------------------
for /f "delims=" %%A in ('wmic csproduct get name') do (
if !lineB! equ 2 set modelName=%%A
set /a lineB+=1)
::set stringval = %stringval%,%modelName%
echo Computer Model,%modelName% >> \\earth\tablets\james\Test.csv
::------------------------
:: Deploy Date
::------------------------
::set stringval = %stringval%,%date% %time%
echo Deploy Date,%date% %time% >> \\earth\tablets\james\Test.csv
::------------------------
:: Get Mac Address
::------------------------
for /f "delims=" %%A in ('ipconfig/all ^| find "Physical Address"') do (
for /f "tokens=2-7 delims=:-" %%B in ("%%A") do (
if "%%C" NEQ "00" set stringval = echo Mac Addresses,%%B-%%C-%%D-%%E-%%F-%%G >> \\earth\tablets\james\Test.csv
)
)
set stringval=%name%
set stringval=%stringval%,%username%
set stringval=%stringval%,%computername%
set stringval=%stringval%,%serialNumber%
set stringval=%stringval%,%modelName%
set stringval=%stringval%,%date% %time%
set stringval=%stringval%,%%B-%%C-%%D-%%E-%%F-%%G
set stringval=%stringval%,%%B-%%C-%%D-%%E-%%F-%%G
echo %stringcat%>>c:\test2.csv
echo %stringval%>>c:\test2.csv
pause