rendered paste bodyHeres the select i'm using now:
$query = "
SELECT UNIX_TIMESTAMP(usageWhen),UNIX_TIMESTAMP(usageOtherTime),usageUser
FROM KSUsage
LEFT JOIN KSComputers ON KSUsage.usageComputerID = KSComputers.computerID
WHERE KSComputers.computerDivisionID = '$division_id'
AND usageEvent = 16
AND ( usageWhen > FROM_UNIXTIME('$start_time') OR usageOtherTime > FROM_UNIXTIME('$start_time') )
AND ( usageWhen < FROM_UNIXTIME('$end_time') OR usageOtherTime < FROM_UNIXTIME('$end_time') )
ORDER BY usageWhen";
What i need is a list of time and the number of logins at that time... for example
(TIMESAMP => 5, TIMESTAMP => 6 ...)
The usageWhen is the logout time, the usageOtherTime is the login time.
mysql> describe KSUsage;
+-----------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+-------+
| usageID | varchar(128) | | PRI | | |
| usageWhen | datetime | YES | | NULL | |
| usageEnum | int(11) | YES | | NULL | |
| usageServerID | int(11) | YES | | NULL | |
| usageServerType | int(11) | YES | | NULL | |
| usageProgramID | varchar(48) | YES | | NULL | |
| usageLicenseID | varchar(32) | YES | | NULL | |
| usageComputerID | varchar(64) | YES | MUL | NULL | |
| usageExpansion | varchar(64) | YES | | NULL | |
| usageUser | varchar(64) | YES | | NULL | |
| usageAddress | varchar(32) | YES | | NULL | |
| usageGroup | varchar(64) | YES | | NULL | |
| usageEvent | int(11) | YES | | NULL | |
| usageReason | int(11) | YES | | NULL | |
| usageTime | int(11) | YES | | NULL | |
| usageOtherTime | datetime | YES | | NULL | |
+-----------------+--------------+------+-----+---------+-------+
16 rows in set (0.00 sec)
Example ROW:
| 413722F600000C34002C7233 | 2004-09-02 09:41:10 | 3124 | 2912819 | 0 | 362E302E302E38 | NULL | N00:03:93:B1:47:BE | NULL | sigler62 | 137.143.100.45 | NULL | 16 | 0 | 1 | 2004-09-02 09:41:11
mysql> describe KSComputers;
+-----------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------+--------------+------+-----+---------+-------+
| computerID | varchar(64) | | PRI | | |
| computerServerID | int(11) | | PRI | 0 | |
| computerName | varchar(64) | YES | | NULL | |
| computerUserName | varchar(64) | YES | | NULL | |
| computerPlatform | int(11) | YES | | NULL | |
| computerProtocol | int(11) | YES | | NULL | |
| computerAddress | varchar(32) | YES | | NULL | |
| computerOSType | int(11) | YES | | NULL | |
| computerOSVersion | int(11) | YES | | NULL | |
| computerOSRelease | int(11) | YES | | NULL | |
| computerCPUType | int(11) | YES | | NULL | |
| computerCPUCount | int(11) | YES | | NULL | |
| computerCPUClock | int(11) | YES | | NULL | |
| computerRAMSize | int(11) | YES | | NULL | |
| computerDiskSize | int(11) | YES | | NULL | |
| computerFreeSpace | int(11) | YES | | NULL | |
| computerMACAddress | varchar(64) | YES | | NULL | |
| computerSite | varchar(64) | YES | | NULL | |
| computerOEMSerial | varchar(64) | YES | | NULL | |
| computerOSSerial | varchar(64) | YES | | NULL | |
| computerLastLogin | datetime | YES | | NULL | |
| computerLastAudit | datetime | YES | | NULL | |
| computerBaseAudit | datetime | YES | | NULL | |
| computerClientVersion | varchar(16) | YES | | NULL | |
| computerUserSession | int(11) | YES | | NULL | |
| computerAcknowledged | int(11) | YES | | NULL | |
| computerAllowed | int(11) | YES | | NULL | |
| computerAudit | int(11) | YES | | NULL | |
| computerDivisionID | int(11) | YES | | NULL | |
| computerAssetID | varchar(64) | YES | | NULL | |
| computerLocation | varchar(64) | YES | | NULL | |
| computerConfirmed | datetime | YES | | NULL | |
| computerConfirmedBy | varchar(64) | YES | | NULL | |
| computerNotes | varchar(255) | YES | | NULL | |
| computerFlags | int(11) | YES | | NULL | |
+-----------------------+--------------+------+-----+---------+-------+
35 rows in set (0.00 sec)