CADminTools:Docs - Documentation for CADminTools LicenseTracker + JoinedUpDatabases

[>img[images/db_app.gif]] Enter codes and descriptions for the licenses you track.\n\nFor example:\n* PROE : Pro/ENGINEER\n* SW : ~SolidWorks\n* INV : Inventor\nBe sure to use these same codes in your LicenseLogging

[>img[images/ct4.gif][http://www.cadmin.co.uk/CADminTools/]] CAD licenses typically cost thousands of pounds/dollars/euros/etc... plus thousands more in related hardware/training.\nPlus, it's often difficult to get a real picture of your CAD license usage, and to link this to your people & design teams.\n\nThis is where CADminTools can help you, whether you're a CAD Systems Administrator, Manager or local Power User. \nIt's a powerful LicenseTracker with JoinedUpDatabases, enabling you to:\n* monitor CAD license usage - including Pro/ENGINEER, Solidworks, Autocad, Inventor, SDRC IDEAS and any other program using Flexlm\n* store all your users, license and hardware info in a linked database\n* create graphs of usage trends over time - build up a picture of how you're using CAD\n* and [[much more|MoreInfo]] . . .\n\nSee the InstallGuide + UserGuide

These online forums are hosted @ SourceForge, and provide a way for people to ask + answer questions about CADminTools:\n\nhttp://www.cadmin.co.uk/CADminTools/ct_forums.htm

Q: Who are you, and what do you do?\nA: My name is Rui Barata, and I'm head of the IT Infrastructure Division of "EP - Estradas de Portugal, E.P.E.".\nMy division is responsible for hardware + software including Autodesk products: purchasing, licensing and budgeting.\n\nQ: What does "Estradas de Portugal" do?\nA: It's Portugal's road management authority, with:\n* 30 sites\n* 1100 users, including mobile users\n* about 300 CAD users\n\nQ: Can you tell us more about your CAD licenses?\nA: Back in September 2002, we had about 89 workstation (standalone) licenses of assorted Autodesk products and versions.\nWe planned to convert to floating licenses, also taking the chance to:\n* Upgrade them to the latest versions\n* Contract subscriptions, so that they keep updated\n* Rationalise ownership of the licenses\n\nDue to the high costs, we estimated the minimum number of replacement licenses to be 109... then I performed a series of calculations, and concluded that 57 licenses would be enough.\nWe convinced management and after 300+ installations, we still haven't run out of licenses.\n\nAfter all this, we were still uncomfortable -- we knew that we had more licenses than we needed, but not by how much. Also we didn't have any way to predict how long they would last.\n\nQ: How did you hear about CADminTools?\nA: Well, I did bug Autodesk Portugal and Micrograf to provide me with such a tool, but they didn't know of any.\nLater I was invited to give a presentation on our license conversion project in September 2005. That's the first time I heard about it.\n\nQ: How have you decided it was the best solution for your organization?\nA:I didn't. I just used what was available. It is free and has few hardware and software requirements, so I could just install and use.\nIf later I found a better solution, I could then switch to it. I still haven't.\n\nQ: How are you using CADminTools?\nA: We installed CADminTools in our license server. We're using it to monitor license usage by\n* Product\n* Department\n* User\n\nQ: What benefits have you already had?\nA: We now know that we do have more licenses than we need -- about 10 more. As usage is not increasing, there is no foreseeable need to buy more licenses.\nOn the other hand, future requests for new products (eg. Autdesk Revit) may be met by crossgrading some of the excess licenses we have instead of buying them anew.\nAlso, we can follow the progress of migration of workstations from the 2004 versions to the 2006 versions of the Autodesk products that we are now performing, in their recorded usage in CADminTools.\n\nQ: What else do you expect to achieve?\nA: I expect much better management of licenses than we have had so far, at least in two ways:\n\n# Predicted license purchases will now be properly included in the yearly budget, based in forecasts using CADminTools usage data, and\n# When there is need to assign the costs of license purchases to departments, we can do it based on increase of license usage by department.\n\nOn a more personal note, ''I also expect to keep contributing to the improvement of this very useful tool. It DOES save money''.

Examples of CADminTools in action...

Here are few errors you may come across in your CADminTools installation - and how to troubleshoot them..\n

CADminTools is Copyright (c) 2005-2007 Edwin Muirhead. All rights reserved. \n\nI've decided to release CADminTools as an open-source project, meaning:\n* you can use it ''free'', distribute & modify as long as the [[copyright notice & disclaimer|http://www.cadmin.co.uk/CADminTools/license.htm]] remain intact.\n* you can ''contribute improvements'' and enhancements, all you need is some simple programming experience.\n* the project is managed on [[sourceforge.net|http://sourceforge.net/projects/cadmintools/]], including all released files.\nTo help with code or testing, please LetMeKnow

Sub-folder ''\sdata\s'' storing the LicenseLogging raw data files... by DateCode.\n\nAll changed files in this folder should be copied from LicenseServer to WebServer after each log (by [[lic_log.bat]]), so the web pages display the latest information.

This is a simple code for the current date, year-mo-da, eg: //2006-05-29//\n\nSay, for instance my server usually displays the date like this (from date /t):\nMon 05/29/2006\n\nThe line in [[lic_log.bat]] splits the date up:\nfor /F "eol=; tokens=1,2,3,4 delims=/ " %%i in ('date /t') do set date=%%l-%%j-%%k\n\nie: date=2006-05-29\n\nYour server may output a different date format, so change this line as required, eg: for a computer showing:\n29/05/2006\nI'd modify the date line to:\nfor /F "eol=; tokens=1,2,3,4 delims=/ " %%i in ('date /t') do set date=%%k-%%j-%%i\n\nIf you have a better method, please LetMeKnow

For normal web access, there are 2 default passwords:\n* edit: ''letmein''\n* delete: ''deletetoo''\nI’d recommend you change them (use a text editor to modify the values in security.asp).\n\nAlso, to open the MS Access DB, there's another default password:\n* CADminlogon\n

CADminTools\nLatestNews\nWhatPeopleSay\nWhereUsed\nWishList\nCopyRight\nDownloadThisDoc

This documentation file is brought to you by TiddlyWiki - an excellent open-source "non-linear notebook".\n\nEverything you see here is on a single page, and since CADminTools is an open-source project, your contributions to the documentation are very welcome...\n\nTo get this documentation, and to contribute, simply [[Right-click - Save Target As...|CADminToolsDocs.htm]] to your hard disk, then add your changes + submit changes back to me... ed [at] cadmin [dot] co [dot] uk\n\nAdd your own "username" for edits + credits! - eg: JoeBloggs...\n\nThanks for your help!

I'm an active CAD Manager, looking after many Pro/E users. In my occasional spare time I run a [[CADmin website|http://www.cadmin.co.uk/]] + [[blog|http://cadmincouk.blogspot.com/]].\n\nI invented this CAD License Tracker when I couldn't find one anywhere else... it started as a simple spreadsheet - then eventually grew to a web-based format. I spoke about the concept at [[PTC/USER 2004|http://www.cadmin.co.uk/articles/ptcuser2004.htm]], then learned more Javascript and ASP and released [[Version 1|HistoryV1]] to the world in Jan-05.\n\nThe latest CADminTools news and information is always on [[the site|http://www.cadmin.co.uk/CADminTools/]].

This open-source project gets most improvements from user suggestions, see the WishList or LetMeKnow...\n\n1.4 - Feb 2005\n* Installer Package available for CADminTools - including both versions, license logging and documentation.\n1.3\n* Ability to pick multiple weeks in license tracker\n* Pick up to 2 licenses to compare\n* Select any combination of locations/servers to monitor\n* Control threshold of users/hours graphed\n* srv.asp: blank license counts replaced by "0", avoiding errors\n* add "Fullscreen" buttons to database panes - to allow opening in fullscreen\n* slight tweak to new user - ignores "----------"\n1.2\n* New Users button operable only when new users are found.\n* Click on new user gives popup "Create User" dialog with username/mcname pre-filled\n1.1\n* minor layout changes, eg: license usage graph "Total = ??? user(s)"\n1.0 - Jan 2005\n* initial launch\n\nAlso see HistoryV3 | HistoryV2

This open-source project gets most improvements from user suggestions, see the WishList or LetMeKnow...\n\n2.11 - June 2005\n* Minor upgrade to fix various code problems\n2.1 - May 2005\n* Password/security improved, displaying current access level (new file 'security.asp' for passwords, etc)\n* In license tracker, included weeks now stay selected\n* Help tips added to license tracker (show in status bar when mouse hovers)\n* Percentages now calculated for licenses & users\n* Graphs - ability to show unused licenses, maximum hours, customise thresholds\n* License tracking - ability to auto-open last week's archive page, building up graphs.\n2.0 - Mar 2005\n* Upgrade page - to bring your CADminTools 1.* database up-to-date... look @ upgrade.asp - then add applications/server details as required\n* Weekly license logs are now stored by date, allowing unlimited archive\n* Ability to set case of usernames/mcnames - eg: lower case for users, UPPERCASE for machines. this is controlled in the info.asp settings dB\n* User lists now show machine name on mouseover\n* All-new license logging configurator (lic_log.htm) - helping you create the scripts to collect license data\n* New applications dB (apps.asp), allowing custom CAD license tracking, eg: SolidWorks, Inventor, etc.. up to 9 different codes\n* View license usage over many archived weeks... only limited by your processing power!\n\nAlso see HistoryV3 | HistoryV1

Since it's an open-source project, most improvements come from user suggestions, see the WishList or LetMeKnow...\n\n3.3 - Jan 2007\n* New feature: CSV Export\n* Auto-archive, thanks to user submission (PeterZehm)\n* New users can be included on license tracker\n* Graphs easier to read, thanks to user suggestion (alternate colours)\n* Tasks dB quicker and cleaner\n* Various performance tweaks, making operation smoother + quicker\n3.2 - June 2006\n* Blog: Mini-preview + Release announcement Improved License Tracker : 4 TIMES FASTER than 3.1!\n* Map - see your users + servers by location\n* Find + filter - improved user searching\n* Matrix - cross-reference design teams by product + location\n* Updated task interface\n* Added smarted error messages for missing files\n3.1 - March 2006\n* NEW: License Ticker - popup window showing up-to-the-minute license usage\n* Changes to interface - cleaner layout, more information on-screen\n* New-style popups in license tracker\n3.01 - December 2005\n* Minor upgrade, released as zip of a few files\n* License tracker - Added filter box: product group - select any sub-set (or combination) of users to track\n* Tasks - New tasks are created with today's date added by default\n3.0 - October 2005\n* License Tracker - enhanced performance\n* License Tracker - "Log" button to bookmark specific License/Location/Server query\n* License Tracker - "Check m/c" button to update your dB when users change computer\n* All Databases - Simple sort + reverse-sort by clicking any header, and export the list of values by double-clicking\n* User Database - Ability to filter by multiple combinations of products/locations\n* User Database - new fields for tracking more info:\n** usertype - eg: Engineer/Drafter, Manager, Sales, etc... - keep track of who's who\n** training - keep track of user training + skill levels\n** totalhours - rolling total of user hours on primary CAD system\n* All new TASK Database - keep track of CAD management workload by user, location, etc... quickly identify the support-intensive areas...\n** including filterable/sortable lists, plus colour graphs\n** note: this is a separate dB file, and doesn't directly affect the main CADminTools database, eg: ignore it if you don't need it...\n\nAlso see HistoryV2 | HistoryV1

OK, here’s a quick guide to installing the CADminTools suite... if you reckon more detail should be included about a specific area, please let us know. The open-source nature of this project means that anyone can contribute, so feel free!\n\nWe’ll start by assuming you’ve downloaded the LatestVersion of the installer (check the site periodically for updates, news, etc.)\n\nThe installer includes:\n* All source files (ASP)\n* User Database (~CADdB.mdb) + Task Database (~TaskdB.mdb)\n* License logging scripts, to track license usage\n\nIf you're upgrading an existing version, you'll want to keep your database of users, etc... so choose the ''Upgrade'' option.\nIf you're starting from scratch, maybe try the ''Test server'' option initially, to see how it works, then install a ''Fresh'' version - with no sample data.\n\nInstall the source files to a folder on a WebServer capable of serving ASP pages (MS IIS or Apache/Sun Chilisoft) eg: \n{{{http://yourwebserver/CADminTools}}}\n\nEnsure you allow Write access to ''~CADdb.mdb'' and ''~TaskdB.mdb'' (the application needs to write to databases). Without this you'll get an ERROR.\n\nAlso, remember to allow Web Sharing on the CADminTools folder.\n[img[http://www.cadmin.co.uk/CADminTools/images/inst2.gif]]\n\nSee the UserGuide for more info

There's a range of databases to keep track of all your resources:\n* UserDB\n* ServerDB\n* ApplicationsDB\n* ProductsDB\n* LocationsDB\n\nThese hold your valuable information. It can be viewed by anyone with access, but to do anything useful you need passwords.\nCADminTools comes with some DefaultPasswords...\n

!Feb-07 : CADminTools 3.3 launched\n* New feature: CSV Export\n* Graphs easier to read, thanks to user suggestion (alternate colours)\n* Various performance tweaks, making operation smoother + quicker\nRead more @ HistoryV3\n\n!Sep-06 : Several updates to license tracker, tasks dB\nOut-of-line graphs sorted, New users can now be included, Preferences save OK, Tasks dB updated: clearer/quicker\n\n!Jul-06 : Various tweaks + new documentation...\n\n!Jun-06 : Version 3.2 released\nRead more [[on the blog|http://cadmincouk.blogspot.com/2006/06/cadmintools-32-is-finally-released.html]]\n\n!March : New code + heavy users\n\nCADminTools Version 3.1+ includes some code by Rui Barata of Portugal's road management authority "~EP-Estradas de Portugal". They are a heavy user of Autodesk products, and Rui has used CADminTools to monitor over 300 CAD users. He helped improve the license tracker archive, allowing unlimited users.

Currently CADminTools Version 3.3 - originally released Feb 2007 - and available on Sourceforge: http://downloads.sourceforge.net/cadmintools/CADminTools_3.3.exe\nRead more @ blog: http://cadmincouk.blogspot.com/2007/02/cadmintools-33.html\n\nPreviously CADminTools Version 3.2 - originally released 30 June 2006 - and available on Sourceforge: http://prdownloads.sourceforge.net/cadmintools/CADminTools_3.2.exe?download\n\nSee more history @ HistoryV3, HistoryV2, HistoryV1

LetMeKnow your suggestions, code improvements or other comments:\nemail: ed [at] cadmin [dot] co [dot] uk\n\nor on the CADminToolsForums

[>img[images/licarc1.gif]] Each week you can archive the previous week's license usage stats... login with "Edit" or "Delete" access, and click the link from the LicenseTracker page.\n\nThis will simply open the previous week tracker with some extra text at the end, eg: [>img[images/licarc2.gif]]\n\nYou could easily archive any previous week you missed (maybe you've been on holiday!) - just add ''&archive=yes'' to the end of a page address.\n\n[>img[images/lic_arc.gif]] This appends data to the archive list, eg: date, maximum, average + total licenses used (for your primary license) and user max + average hours spent... plus a link to the complete userlist for that week.\n\nThe data is also viewable as bar graphs: see LicenseArchiveGraphs\n\n----\n\nPlease note: the archive function only looks at your primary license... you can configure this by your license setup. Plus, any changes you make to the tracker graphs will come through in the archive.

These graphs present the LicenseArchive data in an easier format - so you can quickly see trends, peaks, etc...\n[img[images/lic_arc_graphs.gif]]\n\nAs you hover over the different coloured bars, you'll see details of the average (green), maximum (red) + total (blue) license users per week.\nThere's also data on the average + maximum user hours.

This is where you get the "raw" license usage data... via a batch file + some parsing...\n\nFirst, open the [[lic_log.htm|http://www.cadmin.co.uk/CADminTools/lic_log.htm]] file in your installation... this will help you create your custom [[lic_log.bat]] + [[lic_arc.bat]].\n\nSave these in your License_Log folder, and schedule:\n* [[lic_log.bat]] runs at regular intervals (eg: hourly or half-hourly, based on your [[licTime]])\n* [[lic_arc.bat]] runs each week, to reset the weekly code, just before your tracking starts (eg: on a Sunday)\n

The server where the LicenseLogging takes place... this is usually a Flexlm server, giving direct access to the lmutil lmstat command. In theory, this could be any computer in your network, as long as it has a reliable connection, and can schedule [[lic_log.bat]] to track regularly.\n\nIn fact, this could even be on the same machine as your WebServer...

[img[http://www.cadmin.co.uk/images/ct_ticker1.gif]]\nThis could be useful for you... up-to-the-minute CAD License usage stats.\n\nA popup browser window to monitor your licenses, similar to stock or news tickers.\nYou control the time delay, by setting up a scheduled task on your server.\n\nThis is included as part of 3.1 onwards, or you can download just the ticker...\n\nREQUIREMENTS:\n* server capable of serving ASP pages (eg: IIS)\n* active license server, running Flexlm\n* copy of LMUTIL.EXE from your CAD installation - place in the install folder\n[[DOWNLOAD the package here|http://prdownloads.sourceforge.net/cadmintools/CADminToolsTicker.zip?download]]\n\nThere are 4 files in the ticker package, and you need to tweak each of them in a text editor:\n* servers.txt - add your own server names, each on a new line.\n* licenses.txt - your license code names, each on a new line.\n* ticker.asp - add your server names at the top of the file, editing the sample given.\n* lic_ticker.bat - enter the disk and folder name.\nThe idea for this came from a post on the [[PTC/USER exploders|http://www.ptcuser.org/exploder/]], asking about showing free floating licenses on each desktop. The typical response would be, "use ptcstatus.bat to query the license server"\nI reckoned an auto-updating web-based interface might be easier, so I tweaked the tracker to make a ticker.\n\nPost questions on the [[CADminTools forum|https://sourceforge.net/forum/forum.php?forum_id=436342]], or send comments our way.

This is where you get the graphical presentation of your CAD license usage. The page depends on having input from LicenseLogging.\n\nWhen you hit "GO" you'll get a standard graph of all usage across all locations. You can customise this, and show specific information:\n* Data from any monitored weeks are stored - pick any combination\n* Licenses - select up to 4 to compare\n* Location/Server - any combination\n* Show unused licenses / Show max hours - include potential totals in graphs\n* Choose whether to count 1 for each user, or for every license\n* Thresholds - choose to include a minimum "cut-off" level\n\nThese will give you some control over what data is displayed, for instance you may want to monitor usage in a new group of CAD users, or within a particular area.\n\nOnce the graphs are shown, there's plenty information available:\n\nThere are also a couple of useful buttons:\n* Lists - gives you a quick summary of weekly license activity.\n* NewUsers\n\nSee more: LicenseArchive and LicenseArchiveGraphs\n-----\nPlus, the LicenseTicker was a little spin-off from the tracker, and lets you track usage "real-time"

[>img[images/db_loc.gif]]

[[CADminTools home|http://www.cadmin.co.uk/CADminTools/]]\n\nCADminTools\nLatestNews\nScreenShots\nLatestVersion\nWhatPeopleSay\nWhereUsed\nWishList\nCopyRight\n\nTiddlyWiki

* CADminTools is based on the previous CAD License Tracker and [[User Database|http://www.cadmin.co.uk/articles/user_database.htm]].\n* The whole concept was [[presented at PTC/USER 2004|http://www.cadmin.co.uk/articles/ptcuser2004.htm]]...\n* It's written with ASP (Active Server Pages) with data stored in an Access database\n* It's been tested successfully with these web servers:\n** [[Apache|http://www.apache.org/]] running [[Sun Chilisoft|http://wwws.sun.com/software/chilisoft/]]\n** [[MS IIS|http://www.microsoft.com/]]\n* It's been tested successfully with these browsers:\n** [[Mozilla Firefox 1+|http://www.mozilla.org/products/firefox/]]\n** [[MS Internet Explorer 6+|http://www.microsoft.com/windows/ie/]]

[>img[images/lic_new.gif]]Notifies you of any new users, and allows to easily add them to the database: simply click on the username and you'll get a pre-filled "Add User" popup box.\n

Peter has been active in the CADminToolsForums, and has submitted various suggestions and enhancements, eg:\n* bumpy graphs - led to new code to remove bumps\n* firefox compatibility - led to compatible code (I also prefer firefox)\n* AutoArchive - he suggested some code to improve the weekly archive feature\nHopefully we can get some more info about him here soon... also - if you're keen, submit your own enhancements + get your name here.

Here's a fairly comprehensive LicenseTracker window:\n[img[images/lictracker1.gif]]\n\nPlus, a few screenshots from the JoinedUpDatabases:\n[img[images/db_users.gif]]\n[img[images/db_srv.gif]]\n[img[images/db_loc.gif]]\n[img[images/db_matrix.gif]]

[>img[images/db_srv.gif]] Keep track of your license servers, their licenses and location.\n\nUse the notes field to store ~CPU_ID and other information.

<<search>><<newTiddler>><<saveChanges>>

Documentation for CADminTools LicenseTracker + JoinedUpDatabases

~CADminTools:Docs

http://www.cadmin.co.uk/CADminTools/CADminTools.htm

https://sourceforge.net/projects/cadmintools/\n\nSourceForge.net hosts our file releases and CADminToolsForums. It's a popular repository for all the best open-source software - I highly recommend a look round in there! - particularly these:\n* [[GAIM|https://sourceforge.net/projects/gaim]] - Instant Messenger\n* [[NSIS|https://sourceforge.net/projects/nsis]] - Installer maker\n* [[Stellarium|https://sourceforge.net/projects/stellarium/]] - virtual sky\n* [[Filezilla|https://sourceforge.net/projects/filezilla/]] - excellent FTP program\n* [[7-Zip|https://sourceforge.net/projects/sevenzip/]] - Zip utility\nand many, many more...

.tiddler {\nborder:solid 1px #eee;\npadding:10px;\nmargin:10px;\n}\n

/***\n!Colors Used\n*@@bgcolor(#8cf): #8cf - Background blue@@\n*@@bgcolor(#18f): #18f - Top blue@@\n*@@bgcolor(#04b): #04b - Mid blue@@\n*@@bgcolor(#014):color(#fff): #014 - Bottom blue@@\n*@@bgcolor(#ffc): #ffc - Bright yellow@@\n*@@bgcolor(#fe8): #fe8 - Highlight yellow@@\n*@@bgcolor(#db4): #db4 - Background yellow@@\n*@@bgcolor(#841): #841 - Border yellow@@\n*@@bgcolor(#703):color(#fff): #703 - Title red@@\n*@@bgcolor(#866): #866 - Subtitle grey@@\n!Generic Rules /%==============================================%/\n***/\n/*{{{*/\nbody {\n background: #fff;\n color: #000;\n}\n\na{\n color: #04b;\n}\n\na:hover{\n background: #04b;\n color: #fff;\n}\n\na img{\n border: 0;\n}\n\nh1,h2,h3,h4,h5 {\n color: #703;\n background: #8cf;\n}\n\n.button {\n color: #014;\n border: 1px solid #fff;\n}\n\n.button:hover {\n color: #014;\n background: #fe8;\n border-color: #db4;\n}\n\n.button:active {\n color: #fff;\n background: #db4;\n border: 1px solid #841;\n}\n\n/*}}}*/\n/***\n!Header /%==================================================%/\n***/\n/*{{{*/\n.header {\n background: #000;\n}\n\n.headerShadow {\n color: #8cf;\n}\n\n.headerShadow a {\n font-weight: bold;\n color: #8cf;\n}\n\n.headerForeground {\n color: #fff;\n}\n\n.headerForeground a {\n font-weight: bold;\n color: #8cf;\n}\n\n/*}}}*/\n/***\n!General tabs /%=================================================%/\n***/\n/*{{{*/\n\n.tabSelected{\n color: #014;\n background: #eee;\n border-left: 1px solid #ccc;\n border-top: 1px solid #ccc;\n border-right: 1px solid #ccc;\n}\n\n.tabUnselected {\n color: #fff;\n background: #999;\n}\n\n.tabContents {\n color: #014;\n background: #eee;\n border: 1px solid #ccc;\n}\n\n.tabContents .button {\n border: 0;}\n\n/*}}}*/\n/***\n!Sidebar options /%=================================================%/\n~TiddlyLinks and buttons are treated identically in the sidebar and slider panel\n***/\n/*{{{*/\n#sidebar {\n}\n\n#sidebarOptions input {\n border: 1px solid #04b;\n}\n\n#sidebarOptions .sliderPanel {\n background: #8cf;\n}\n\n#sidebarOptions .sliderPanel a {\n border: none;\n color: #04b;\n}\n\n#sidebarOptions .sliderPanel a:hover {\n color: #fff;\n background: #04b;\n}\n\n#sidebarOptions .sliderPanel a:active {\n color: #04b;\n background: #fff;\n}\n/*}}}*/\n/***\n!Message Area /%=================================================%/\n***/\n/*{{{*/\n#messageArea {\n border: 1px solid #841;\n background: #db4;\n color: #014;\n}\n\n#messageArea .button {\n padding: 0.2em 0.2em 0.2em 0.2em;\n color: #014;\n background: #fff;\n}\n\n/*}}}*/\n/***\n!Popup /%=================================================%/\n***/\n/*{{{*/\n.popup {\n background: #18f;\n border: 1px solid #04b;\n}\n\n.popup hr {\n color: #014;\n background: #014;\n border-bottom: 1px;\n}\n\n.popup li.disabled {\n color: #04b;\n}\n\n.popup li a, .popup li a:visited {\n color: #eee;\n border: none;\n}\n\n.popup li a:hover {\n background: #014;\n color: #fff;\n border: none;\n}\n/*}}}*/\n/***\n!Tiddler Display /%=================================================%/\n***/\n/*{{{*/\n.tiddler .defaultCommand {\n font-weight: bold;\n}\n\n.shadow .title {\n color: #866;\n}\n\n.title {\n color: #703;\n}\n\n.subtitle {\n color: #866;\n}\n\n.toolbar {\n color: #04b;\n}\n\n.tagging, .tagged {\n border: 1px solid #eee;\n background-color: #eee;\n}\n\n.selected .tagging, .selected .tagged {\n background-color: #ddd;\n border: 1px solid #bbb;\n}\n\n.tagging .listTitle, .tagged .listTitle {\n color: #014;\n}\n\n.tagging .button, .tagged .button {\n border: none;\n}\n\n.footer {\n color: #ddd;\n}\n\n.selected .footer {\n color: #888;\n}\n\n.sparkline {\n background: #8cf;\n border: 0;\n}\n\n.sparktick {\n background: #014;\n}\n\n.errorButton {\n color: #ff0;\n background: #f00;\n}\n\n.cascade {\n background: #eef;\n color: #aac;\n border: 1px solid #aac;\n}\n\n.imageLink, #displayArea .imageLink {\n background: transparent;\n}\n\n/*}}}*/\n/***\n''The viewer is where the tiddler content is displayed'' /%------------------------------------------------%/\n***/\n/*{{{*/\n\n.viewer .listTitle {list-style-type: none; margin-left: -2em;}\n\n.viewer .button {\n border: 1px solid #db4;\n}\n\n.viewer blockquote {\n border-left: 3px solid #666;\n}\n\n.viewer table {\n border: 2px solid #333;\n}\n\n.viewer th, thead td {\n background: #db4;\n border: 1px solid #666;\n color: #fff;\n}\n\n.viewer td, .viewer tr {\n border: 1px solid #666;\n}\n\n.viewer pre {\n border: 1px solid #fe8;\n background: #ffc;\n}\n\n.viewer code {\n color: #703;\n}\n\n.viewer hr {\n border: 0;\n border-top: dashed 1px #666;\n color: #666;\n}\n\n.highlight, .marked {\n background: #fe8;\n}\n/*}}}*/\n/***\n''The editor replaces the viewer in the tiddler'' /%------------------------------------------------%/\n***/\n/*{{{*/\n.editor input {\n border: 1px solid #04b;\n}\n\n.editor textarea {\n border: 1px solid #04b;\n width: 100%;\n}\n\n.editorFooter {\n color: #aaa;\n}\n\n/*}}}*/

/***\n!Sections in this Tiddler:\n*Generic rules\n**Links styles\n**Link Exceptions\n*Header\n*Main menu\n*Sidebar\n**Sidebar options\n**Sidebar tabs\n*Message area\n*Popup\n*Tabs\n*Tiddler display\n**Viewer\n**Editor\n*Misc. rules\n!Generic Rules /%==============================================%/\n***/\n/*{{{*/\nbody {\n font-size: .75em;\n font-family: tahoma,arial,helvetica;\n position: relative;\n margin: 0;\n padding: 0;\n}\n\nh1,h2,h3,h4,h5 {\n font-weight: bold;\n text-decoration: none;\n padding-left: 0.4em;\n}\n\nh1 {font-size: 1.35em;}\nh2 {font-size: 1.25em;}\nh3 {font-size: 1.1em;}\nh4 {font-size: 1em;}\nh5 {font-size: .9em;}\n\nhr {\n height: 1px;\n}\n\na{\n text-decoration: none;\n}\n\nol { list-style-type: decimal }\nol ol { list-style-type: lower-alpha }\nol ol ol { list-style-type: lower-roman }\nol ol ol ol { list-style-type: decimal }\nol ol ol ol ol { list-style-type: lower-alpha }\nol ol ol ol ol ol { list-style-type: lower-roman }\nol ol ol ol ol ol ol { list-style-type: decimal }\n/*}}}*/\n/***\n''General Link Styles'' /%-----------------------------------------------------------------------------%/\n***/\n/*{{{*/\n.externalLink {\n text-decoration: underline;\n}\n\n.tiddlyLinkExisting {\n font-weight: bold;\n}\n\n.tiddlyLinkNonExisting {\n font-style: italic;\n}\n\n/* the 'a' is required for IE, otherwise it renders the whole tiddler a bold */\na.tiddlyLinkNonExisting.shadow {\n font-weight: bold;\n}\n/*}}}*/\n/***\n''Exceptions to common link styles'' /%------------------------------------------------------------------%/\n***/\n/*{{{*/\n\n#mainMenu .tiddlyLinkExisting, \n#mainMenu .tiddlyLinkNonExisting,\n#sidebarTabs .tiddlyLinkExisting,\n#sidebarTabs .tiddlyLinkNonExisting{\n font-weight: normal;\n font-style: normal;\n}\n\n/*}}}*/\n/***\n!Header /%==================================================%/\n***/\n/*{{{*/\n\n.header {\n position: relative;\n}\n\n.header a:hover {\n background: transparent;\n}\n\n.headerShadow {\n position: relative;\n padding: 4.5em 0em 1em 1em;\n left: -1px;\n top: -1px;\n}\n\n.headerForeground {\n position: absolute;\n padding: 4.5em 0em 1em 1em;\n left: 0px;\n top: 0px;\n}\n\n.siteTitle {\n font-size: 3em;\n}\n\n.siteSubtitle {\n font-size: 1.2em;\n}\n\n/*}}}*/\n/***\n!Main menu /%==================================================%/\n***/\n/*{{{*/\n#mainMenu {\n position: absolute;\n left: 0;\n width: 10em;\n text-align: right;\n line-height: 1.6em;\n padding: 1.5em 0.5em 0.5em 0.5em;\n font-size: 1.1em;\n}\n\n/*}}}*/\n/***\n!Sidebar rules /%==================================================%/\n***/\n/*{{{*/\n#sidebar {\n position: absolute;\n right: 15px;\n width: 16em;\n font-size: .9em;\n}\n/*}}}*/\n/***\n''Sidebar options'' /%----------------------------------------------------------------------------------%/\n***/\n/*{{{*/\n#sidebarOptions {\n padding-top: 0.3em;\n}\n\n#sidebarOptions a {\n margin: 0em 0.2em;\n padding: 0.2em 0.3em;\n display: block;\n}\n\n#sidebarOptions input {\n margin: 0.4em 0.5em;\n}\n\n#sidebarOptions .sliderPanel {\n margin-left: 1em;\n padding: 0.5em;\n font-size: .85em;\n}\n\n#sidebarOptions .sliderPanel a {\n font-weight: bold;\n display: inline;\n padding: 0;\n}\n\n#sidebarOptions .sliderPanel input {\n margin: 0 0 .3em 0;\n}\n/*}}}*/\n/***\n''Sidebar tabs'' /%-------------------------------------------------------------------------------------%/\n***/\n/*{{{*/\n\n#sidebarTabs .tabContents {\n width: 15em;\n overflow: hidden;\n}\n\n/*}}}*/\n/***\n!Message area /%==================================================%/\n***/\n/*{{{*/\n#messageArea {\nposition:absolute; top:0; right:0; margin: 0.5em; padding: 0.5em;\n}\n\n*[id='messageArea'] {\nposition:fixed !important; z-index:99;}\n\n.messageToolbar {\ndisplay: block;\ntext-align: right;\n}\n\n#messageArea a{\n text-decoration: underline;\n}\n/*}}}*/\n/***\n!Popup /%==================================================%/\n***/\n/*{{{*/\n.popup {\n font-size: .9em;\n padding: 0.2em;\n list-style: none;\n margin: 0;\n}\n\n.popup hr {\n display: block;\n height: 1px;\n width: auto;\n padding: 0;\n margin: 0.2em 0em;\n}\n\n.popup li.disabled {\n padding: 0.2em;\n}\n\n.popup li a{\n display: block;\n padding: 0.2em;\n}\n/*}}}*/\n/***\n!Tabs /%==================================================%/\n***/\n/*{{{*/\n.tabset {\n padding: 1em 0em 0em 0.5em;\n}\n\n.tab {\n margin: 0em 0em 0em 0.25em;\n padding: 2px;\n}\n\n.tabContents {\n padding: 0.5em;\n}\n\n.tabContents ul, .tabContents ol {\n margin: 0;\n padding: 0;\n}\n\n.txtMainTab .tabContents li {\n list-style: none;\n}\n\n.tabContents li.listLink {\n margin-left: .75em;\n}\n/*}}}*/\n/***\n!Tiddler display rules /%==================================================%/\n***/\n/*{{{*/\n#displayArea {\n margin: 1em 17em 0em 14em;\n}\n\n\n.toolbar {\n text-align: right;\n font-size: .9em;\n visibility: hidden;\n}\n\n.selected .toolbar {\n visibility: visible;\n}\n\n.tiddler {\n padding: 1em 1em 0em 1em;\n}\n\n.missing .viewer,.missing .title {\n font-style: italic;\n}\n\n.title {\n font-size: 1.6em;\n font-weight: bold;\n}\n\n.missing .subtitle {\n display: none;\n}\n\n.subtitle {\n font-size: 1.1em;\n}\n\n/* I'm not a fan of how button looks in tiddlers... */\n.tiddler .button {\n padding: 0.2em 0.4em;\n}\n\n.tagging {\nmargin: 0.5em 0.5em 0.5em 0;\nfloat: left;\ndisplay: none;\n}\n\n.isTag .tagging {\ndisplay: block;\n}\n\n.tagged {\nmargin: 0.5em;\nfloat:right;\n}\n\n.tagging, .tagged {\nfont-size: 0.9em;\npadding: 0.25em;\n}\n\n.tagging ul, .tagged ul {\nlist-style: none;margin: 0.25em;\npadding: 0;\n}\n\n.tagClear {\nclear: both;\n}\n\n.footer {\n font-size: .9em;\n}\n\n.footer li {\ndisplay: inline;\n}\n/***\n''The viewer is where the tiddler content is displayed'' /%------------------------------------------------%/\n***/\n/*{{{*/\n* html .viewer pre {\n width: 99%;\n padding: 0 0 1em 0;\n}\n\n.viewer {\n line-height: 1.4em;\n padding-top: 0.5em;\n}\n\n.viewer .button {\n margin: 0em 0.25em;\n padding: 0em 0.25em;\n}\n\n.viewer blockquote {\n line-height: 1.5em;\n padding-left: 0.8em;\n margin-left: 2.5em;\n}\n\n.viewer ul, .viewer ol{\n margin-left: 0.5em;\n padding-left: 1.5em;\n}\n\n.viewer table {\n border-collapse: collapse;\n margin: 0.8em 1.0em;\n}\n\n.viewer th, .viewer td, .viewer tr,.viewer caption{\n padding: 3px;\n}\n\n.viewer pre {\n padding: 0.5em;\n margin-left: 0.5em;\n font-size: 1.2em;\n line-height: 1.4em;\n overflow: auto;\n}\n\n.viewer code {\n font-size: 1.2em;\n line-height: 1.4em;\n}\n/*}}}*/\n/***\n''The editor replaces the viewer in the tiddler'' /%------------------------------------------------%/\n***/\n/*{{{*/\n.editor {\nfont-size: 1.1em;\n}\n\n.editor input, .editor textarea {\n display: block;\n width: 100%;\n font: inherit;\n}\n\n.editorFooter {\n padding: 0.25em 0em;\n font-size: .9em;\n}\n\n.editorFooter .button {\npadding-top: 0px; padding-bottom: 0px;}\n\n.fieldsetFix {border: 0;\npadding: 0;\nmargin: 1px 0px 1px 0px;\n}\n/*}}}*/\n/***\n!Misc rules /%==================================================%/\n***/\n/*{{{*/\n.sparkline {\n line-height: 1em;\n}\n\n.sparktick {\n outline: 0;\n}\n\n.zoomer {\n font-size: 1.1em;\n position: absolute;\n padding: 1em;\n}\n\n.cascade {\n font-size: 1.1em;\n position: absolute;\n overflow: hidden;\n}\n/*}}}*/

The open-source framework this page is built on... an excellent bit of kit, allowing easy editing + formatting, etc..\n\nTiddlyWiki is © [[osmosoft|http://www.osmosoft.com]] 2005\n\nSee more on the [[TiddlyWiki site|http://www.tiddlywiki.com/]]

[>img[images/db_users.gif]] Keep track of your users - store, filter + sort:\n* username\n* computer\n* email address (handy for sending out updates, etc)\n* product group\n* location\n* training (useful to note a person's skills + requirements)\n* CAD usage (stats get added automatically by LicenseArchive)

This will give you a quick introduction to some of the features of the CADminTools suite... (also see ScreenShots)\nIf you reckon more detail should be included about a specific area, please let us know. The open-source nature of this project means that anyone can contribute, so feel free!\n\nWe’ll start by assuming you’ve got the ASP & htm files installed on a web server.\n\nThe two main parts of CADminTools are the JoinedUpDatabases (users, servers, products & locations) and LicenseTracker (graphs of license usage).

<div class='toolbar' macro='toolbar -closeTiddler closeOthers +editTiddler permalink references jump'></div>\n<div class='title' macro='view title'></div>\n<div class='viewer' macro='view text wikified'></div>\n<div class='tagClear'></div>\n<div class='tagging' macro='tagging'></div>\n<div class='tagged' macro='tags'></div>\n<div class='tagClear'></div>\n

A machine capable of serving ASP pages, eg:\n* Windows XP Pro or Windows Server with MS IIS\n* Apache with Sun Chilisoft or equivalent\nThis should have a reliable connection to your LicenseServer (they may even be on the same machine!)\nSee MoreInfo.

!What do people say about it?\nHere are some quotes from CAD admins and users who have already worked with CADminTools...\n* "We have been using CADminTools for sometime now and we love it. We have essentially abandonded the SAM Report tools we were using and moved 100% to CADminTools for our Pro/E usage data."\n* "...Thanx for this wonderful tool!!!! Works like charm ;) I track the usage (for over 500 users worldwide) of 15 different licenses with this..."\n* "...thanks for putting this together. It really fills a need for us..."\n* "...I have been searching high and low for a Pro/E license tracking/usage program. And finally, I found your website via ptcuser.org..."\n* "...I'm very keen to introduce the license logger to our setup. Top marks for developing it...."\n* "...Today I found your Licence Tracker. Very cool solution!"\nAlso see: [[Case Study : EP Portugal]]

Where CADminTools is already used around the world (Let us know your information, and appear here too...)\n\n>We have ''40 licenses'' Autodesk MAP, 7 CIVIL 3D, 7 Architectural, about 300 users have access from ''28 sites'' connected via WAN... I can now take the values and graphs from CADminTools, extrapolate, and have a __forecast of how much licenses I'll have to buy during the next budget year__ [Rui : Portugal]\n\n>We have 3 license server, at ''3 locations'' in Europe. I´m tracking ~ ''40 Pro/E licenses'', all additional Pro/E features like AGW, EFX... and one additional IDEAS license server. [Axel : Germany]\n\n>We track 300 users across ''20+ locations'' and ''120 Pro/E and Pro/I licenses'', plus Design Animation, Mechanica, Piping, SDRC [Edwin : UK]\n\n>I am tracking all of our Pro/E products, ANSYS and ~MathCAD licenses with CADminTools. There's a total of ''25 licenses'' right now and they are all here in Tucson, but I am planning to expand the license logger to our India office. They have at least another 6 licenses. [Richard : Arizona]\n\n>I use CADminTools mainly just to periodically check license usage. We have around ''50 Pro/E'' licenses, 50 Pro/I, 3 Pro/MECH, 10 ~ProductVIEW, 4 Pro/NC and 6 Pro/I Toolkit Access licenses. CADminTools presents the license usage data in a __user-friendly, easy-to-understand graphical format that is easily customizable__. [Perry : Ontario]

What we'd like to see in upcoming versions...\n\n>I could use more statistic for users. What time and from which servers have a user take a license. I would also be able to see when a user use a local or remote license. Another wish option to ''see more information in the userlist'' you get when click on the graph. Ex location would be nice or the posibility to config what you want to see or perhaps all info about the user like location, notes, email.. [Johannes : Denmark]\n\nThese are on my agenda for upcoming versions:\n* Show more user info on the graphs\n* Include server-management tools\n\nPreviously covered: \n>The date for each day shown below the license tracker graph, plus an easy way to get the ''data extracted to an excel sheet'' [Axel : Germany] - ''CSV export in 3.3''\n\n>Do you have a suggested technique for ''exporting the license usage data into Excel''? My boss would prefer to see the data in a line graph. [Richard : Arizona] - ''CSV export in 3.3''

Number of hours between license logging, eg: 1 = every hour, 0.5 = every 30 minutes, etc...\n\nDefault = 1\n\nChange in settings table.

This will reset your weekly license tracking:\n* Store current DateCode in [[lic_datecode]]

This file stores a DateCode for the first day of the current week, which is used as the filename for the current week's license data in the DataFolder.\nMake sense??

A one-liner text file showing the last time the tracker ran, created by [[lic_log.bat]] and shown in LicenseTracker window... DATE @ TIME\nUseful to check the tracker's working OK

This batch script runs every hour (or half-hour, or whenever, just remember to set the appropriate [[licTime]]) - and does a few things:\n* Stores current date + time in [[lic_last]]\n* Stores current list of weekly codes in [[lic_weeks]]\n*Collects your license usage data (using lmutil lmstat):\n** license\n** user\n** computername\n** server\n* Copies a few files to the WebServer, using FTP or simple copy:\n** latest DateCode file (eg: 2006-07-03)\n** [[lic_last]]\n** [[lic_weeks]]

A text file created by [[lic_log.bat]] - listing the contents of the DataFolder, showing weeks available to track.