Open-AudIT https://www.open-audit.org/phpBB3/ |
|
OAv2 https://www.open-audit.org/phpBB3/viewtopic.php?f=20&t=2855 |
Page 4 of 4 |
Author: | ccpyle [ Fri Feb 05, 2010 11:17 pm ] |
Post subject: | Re: OAv2 |
[quote]Can I ask why you use CSV export ? I built a lot of my own queries based on our task at hand. Being able to bring a report into excel and work off of it was invaluable. example: We migrated DNS servers. I created a query that listed computer name, IP address, DNS1-3, and WINS1-2. I could export to CSV, identify the ones that needed manual correction, and delegate lists to employees for remediation. [quote]If anyone wants to contribute a logo, feel free. My wife is a Graphic Designer. I've been searching for some way that we can contribute to this software. I think we just found it. |
Author: | Mark [ Sat Feb 06, 2010 6:44 am ] |
Post subject: | Re: OAv2 |
[quote]I built a lot of my own queries based on our task at hand. Being able to bring a report into excel and work off of it was invaluable. example: We migrated DNS servers. I created a query that listed computer name, IP address, DNS1-3, and WINS1-2. I could export to CSV, identify the ones that needed manual correction, and delegate lists to employees for remediation. I wonder how close OAv2 will work for you "out of the box"... Groups have some things I haven't made a front end for, as yet. One of them is the ability to specify (on a per Group basis) which columns you would like to display on the "List" type pages. It would be easy to create a Group containing every device (or every Windows system), that displays those columns (DNS1, 2, WINs, etc). [quote]My wife is a Graphic Designer. I've been searching for some way that we can contribute to this software. I think we just found it. Sweet - I'd prefer it in SVG format (if possible). Post it here and we can all take a look !!! |
Author: | lspyle [ Sun Feb 07, 2010 2:24 am ] |
Post subject: | Re: OAv2 |
Hi Mark, I'm Lacey...the wife and Graphic Designer. I tried to send you a PM so this thread wouldn't get too off topic. Just wanted to introduce myself and create a direct point of contact in case you need it. |
Author: | wnyhelpdesk [ Sun Mar 14, 2010 7:44 am ] | |||
Post subject: | Re: OAv2 | |||
Great work so far. Here are some things I'd like to see... 1. I think that it'd be beneficial to have a better donation mechanism. Something like a graph that shows a target goal and brief explanation of the goal. List top contributors etc, put this information on the main page so that it can't be missed. 2. Regarding OAV2 I have tested it out and like how you have leveraged jquery. Having used jquery in OAV1 to make ajax enabled tabular data as opposed to HTML tables I think that OAV2 can benefit from leveraging jquery + extjs to provide newer modern front end. Let me show you an example: I used jquery + jqgrid [url]http://trirand.com/blog/jqgrid/jqgrid.html[/url] but extjs [url]http://www.extjs.com/[/url] offers more functionality such as exporting to csv. ExtJS & JQGRID have an Open Source License. You can easily search/re-order columns, resize columns, have multiple grid, have actions such as populate a second grid upon clicking on a cell on the first grid. As you can see you can also have footer data. It's Excel on steroids, I think a full blown implementation of this would blow out the current front end that you have for OAV2 now. Plus you can use JQUERY Themeroller.... If you want I can provide more functionality samples. Hope that this example can give you some ideas. And if I can make myself useful don't hesitate to let me know.
|
Author: | homebunny [ Tue Mar 23, 2010 1:32 am ] |
Post subject: | Re: OAv2 |
Hi wnyhelpdesk, i like that revolutionairy style !! |
Author: | jrc_101077 [ Thu Sep 16, 2010 8:51 pm ] |
Post subject: | Re: OAv2 |
Good afternoon, I am using Openaudit and it Works very well . I am interested in making several changes, but when I verify the structure of the application I get confused, I want to create an option for audit.vbs so that it verifies the profiles that are in “documents and settings†and at the same time creates a list and adds it to the PC information. I have almost finished it but I have used the same table from pagefile. How I can get the created list to be saved on a new table? Thank you very much for your attention. audit.vbs '''''''''''''''''''''''''''''''''''' ' Pagefile information ' '''''''''''''''''''''''''''''''''''' comment = "Pagefile Info" Echo(comment) On Error Resume Next Set colItems = objWMIService.ExecQuery("Select * from Win32_PageFile",,48) For Each objItem in colItems form_input = "pagefile^^^" & clean(objItem.Name) & "^^^" & clean(objItem.InitialSize) & "^^^" & clean(objItem.MaximumSize) & "^^^" entry form_input,comment,objTextFile,oAdd,oComment form_input = "" Next '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Const USER_PROFILE = &H28& Dim objFolder, numSize Set WSHNetwork = WScript.CreateObject ("WScript.Network") Set objShell = CreateObject("Shell.Application") Set objFolder = objShell.Namespace(USER_PROFILE) Set objFolderItem = objFolder.Self Carpeta = "c:\Documents and Settings" Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFolder = objFSO.GetFolder(Carpeta) Set colSubfolders = objFolder.Subfolders for Each objsubFolder in colSubfolders FileSize = int(objsubFolder.Size/1048576) MaxFileSize = int(objsubFolder.Size/1048576) form_input = "pagefile^^^" & objsubFolder.Name & "^^^" & FileSize & "^^^" & MaxFileSize & "^^^" entry form_input,comment,objTextFile,oAdd,oComment form_input = "" Next ''''''''''''''''''''''''''''''''''''''''' ' Motherboard information ' ''''''''''''''''''''''''''''''''''''''''' comment = "Motherboard Info" Echo(comment) On Error Resume Next Set colItems = objWMIService.ExecQuery("Select * from Win32_BaseBoard",,48) For Each objItem in colItems Manufacturer = clean(objItem.Manufacturer) Product = clean(objItem.Product) Next ' Counting CPU sockets Set colItems = objWMIService.ExecQuery("SELECT * FROM Win32_Processor",,48) SocketDesignation = "" CpuSockets = 0 For Each objItem In colItems If Instr(SocketDesignation, objItem.SocketDesignation) = 0 Then CpuSockets = CpuSockets + 1 SocketDesignation = SocketDesignation & objItem.SocketDesignation End If Next ' Counting RAM slots Set colItems = objWMIService.ExecQuery("Select MemoryDevices FROM Win32_PhysicalMemoryArray ",,48) For Each objItem in colItems MemorySlots = objItem.MemoryDevices Next form_input = "motherboard^^^" & Manufacturer & "^^^" & Product & "^^^" & CpuSockets & "^^^" & MemorySlots & "^^^" entry form_input,comment,objTextFile,oAdd,oComment form_input = "" system_viewdef_os.php "perfiles"=>array( "headline"=>__("Perfiles"), "sql"=>"SELECT * FROM pagefile WHERE pagefile_uuid = '".$_REQUEST["pc"]."' AND pagefile_name NOT LIKE '%pagefile.sys%' AND pagefile_timestamp = '".$GLOBAL["system_timestamp"]."' ORDER BY pagefile_name", "image"=>"images/shared_drive_l.png", "table_layout"=>"horizontal", "fields"=>array("10"=>array("name"=>"pagefile_name", "head"=>__("Name"),), "20"=>array("name"=>"pagefile_initial_size", "head"=>__("Initial Size"),), "30"=>array("name"=>"pagefile_max_size", "head"=>__("Maximum Size"),), ), ), |
Page 4 of 4 | All times are UTC + 10 hours |
Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |