If you have a large network, it??™s unlikely that you??™ll want
to view every one of those individual records.
You have options at your disposal when working with individual commands. For example,
many commands and utilities support the Comma Separated Value (CSV) format. When working
with one of these utilities, you simply specify that you don??™t want headers and that the system
should use the CSV format. Unfortunately, these utilities won??™t address special needs, such as error
reports or a listing of interesting files on a machine (perhaps an unacceptable or unsupported application,
temporary files, viruses, adware, or spyware). For all of these needs and many more, you
must create the output in a form that lends itself to use with a database. Fortunately, creating your
own CSV output (a data form commonly accepted by databases) isn??™t difficult. Listing 5.7 shows
one way to do it with a list of temporary files. You can obtain this example on the Sybex Web site
at http://www.sybex.com/WileyCDA/.
Listing 5.7: Creating Output for a Database
@ECHO OFF
REM Clean up any existing output file.
IF EXIST Output.CSV Del Output.CSV
REM Create a new environment variable to hold the static
REM data for this session.
Pages:
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