Location: PHPKode > projects > Network Asset Management Archive > nama/liaso/newreport.php
<body text="#000000" bgcolor="#F9F3E0" link="#0000EE" vlink="#551A8B" alink="#FF0000">
include "../connect.php";
$now = date("j/m/y h:i:s",time());
print '<form name="NewReport" method="get" action="custreport.php">';
print 'Enter Title:	<input type="text" name="title" value="" size="50" maxlength="50">';
print 'Enter Query:	<input type="text" name="query" value="" size="500" maxlength="500">';
print '<input type="submit" name="Submit" value="Submit">';
print '</form>';
You can use this form to design custom reports from NAMA database.  Put the name you would like for the report in the first box.  In the second box you can put any select query to the database leaving off the select keyword.  ex <b>BUILDING, ROOM, BARCODE from ARP_TABLE where (building='8000') and (os starts with 'Windows') </b> would return a list of barcodes for all windows machines in building 8000. You can then book mark the result page or send the link to others where they can reproduce the report. <br>
You can use the link below to find a list of tables and columns in the database.<br>   
<a href="/liaso/iat-db/Index.html" target="_new">Database Tables</a>

Return current item: Network Asset Management Archive