JSI Tip 0754. Generate a sorted, formated, user report.

Downloads
JSIUName.zip

JSIUName.bat is a script that produces a sorted, formated, user report. The syntax is:

JSIUName ReportFile.htm Lines \[/u\] /\[/f\] where:

Parameter	M e a n i n g
ReportFile.htm	The full path to the output file.
Lines	The number of lines (not including headings) that fit on a landscaped page. This is dependent on font size. This number must be correct to get proper pagination.
/u	Sort the report by UserName. This is the default.
/f	Sort the report by Full Name. The users Last Name is located and sorted first.

Here is a sample, sorted by UserName:

User Name	F u l l N a m e	D e s c r i p t i o n..................................................................
IUSR_XXXX	Internet Guest Account	InternetServer Anonymous Access
JERRY	Jerold Schulman	President
Jennifer	Jennifer Schulman	CFO
Opalis	OpalisRobot	OpalisRobot
. . .	. . .	. . .
ULTRABAC	ULTRABAC	ULTRABAC
three part user	Four Part User Name	Test user with spaces.

Here is the same data, sorted by Full Name:

User Name	F u l l N a m e	D e s c r i p t i o n..................................................................
IUSR_XXXX	Account, Internet Guest	InternetServer Anonymous Access
three part user	Name, Four Part User	Test user with spaces.
Opalis	OpalisRobot	OpalisRobot
Jennifer	Schulman, Jennifer	CFO
JERRY	Schulman, Jerold	President
. . .	. . .	. . .
ULTRABAC	ULTRABAC	ULTRABAC

After running the report, double click on ReportFile.htm and it will open in your browser. When printing, select Landscape. The report will print, complete with page numbers, and date (added by IE and Netscape).

JSIUName utilizes fsort and the public domain SHOWMBRS program.

JSIUName displays Domain Users, so it should be run on a Domain Controller. If you wish to run it on an non-DC, change the "Domain Users" parameter of SHOWMBRS to "Users".

Since JSIUName generates HTML statements, download JSIUName.zip now.

Comments

Plain text