MySQL Forums
Forum List  »  Newbie

Re: Help with some query's
Posted by: Max Eggenhuizen
Date: November 21, 2015 02:16PM

Peter, sorry if i am not clear about all. Doing my best to explain it on a easy way.

Here is what u asked:

pcs

CREATE TABLE `pcs` (
`user` varchar(255) NOT NULL,
`pcnr` varchar(255) NOT NULL,
`ip` varchar(255) NOT NULL,
`mac` varchar(255) NOT NULL,
`winv` varchar(255) NOT NULL,
`sp` varchar(255) NOT NULL,
`uou` varchar(255) NOT NULL,
`sou` varchar(255) NOT NULL,
`ldate` varchar(255) NOT NULL,
`model` varchar(255) NOT NULL,
`serial` varchar(255) NOT NULL,
`biosv` varchar(255) NOT NULL,
`tel` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`dorl` varchar(255) NOT NULL,
`memory` varchar(255) NOT NULL,
`auto` varchar(255) NOT NULL,
`id` int(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1

Maybe its better if i explain what we currently have in use, and what i want to be in a Database.

Currently there is a network folder named PCs every user that logs in gets a script that writes a string to the pcs folder SYSTEMNAME.txt example of the string:

USER|PCNAME|IP|MAC|etc etc..

If the file already exist then it writes 1 line in it, but if there already 20 lines the oldest will be removed.

In the morning im running a "collect" script it will read every file in the PCS map and counts the username that is most in there. THAT line (string) will be placed in TOTAL.txt so when the script is done (and if we have 5000 systems) there will be 5000 records in total.txt

In that mysql database all logins from every system is there maybe i didint made that correct?

I hope you know now what i mean =)

Options: ReplyQuote


Subject
Written By
Posted
November 20, 2015 02:32PM
November 20, 2015 02:59PM
November 20, 2015 03:43PM
November 20, 2015 03:59PM
November 20, 2015 05:00PM
Re: Help with some query's
November 21, 2015 02:16PM
November 21, 2015 04:08PM
November 21, 2015 04:55PM
November 21, 2015 05:04PM
November 22, 2015 03:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.