Wiseman82

No, you would need to explicitly ask for the passwords to be changed. The old version of "Edit In Excel" (The one that was part of Password Control) used to update all attributes in the Excel sheet if the value was different to what is stored in AD. This had a greater chance of you overwriting another users update. The new version (Bulk AD Users) allows you to tell the application which attributes you have updated and only those specified will be updated. Note: There is no update via Excel. Only "Edit In Excel" which takes the current contents of the grid and allows you to update in Excel. When you close and save the Excel file, the application will then ask you which columns you want to update. There is also a CSV Update tool included in the application which can also be used to perform updates. I'm planning to extend the update features to any data source in future, but it will be a while before the next release.

The Edit In Excel feature uses the ADsPath column to bind to user accounts in AD. The order of the rows are not important.

Thanks for the vote of confidence in my software. Performing Bulk Updates to Activie Directory always has an element of risk associated with it. Regardless of the software/script you use, test the update in a qa environment first and also have a recent backup of your directory database when performing the update in your live environment. The rollback feature in Bulk AD Users provides an additional level of protection making it unlikely that you would need to perform an authoritative restore. I agree with the first suggestion about using the Edit In Excel feature to perform the update. You should be able to use a formula in Excel to extract the firstname/surname - something like this: =MID(A1,1,FIND(" ",A1,1)-1) =MID(A1,FIND(" ",A1,1)+1,LEN(A1)) (Replace A1 with the cell containing the full name) There formula just splits the first name and surname based on the first space character - you might need to review the data after applying the formula to all rows to ensure that there are no anomalies. Good luck.

I'm not familiar with Apache but it does sound like the integrated authentication is enabled as users are prompted for their logon and are able to logon with their Windows credentials. The issue is to make this process automatic - I'm not aware of anything special you need to do in IIS, but Apache might be a different issue. I do know that you need to modify the browser settings to allow the automatic logon to work when using a Windows authentication app in IIS. I'd check the browser settings first then look if any server side options need to be enabled when using Apache.

In IE Advanced Settings check that "Enable Integrated Windows Authentication" is enabled. Add the site to the "Local Intranet" zone. The above should do the trick. If not check that the security settings have "Automatic logon only in Intranet zone". (Custom Level button in Security tab)

Glad you like my site. I wrote an Excel spreadsheet app a few years ago that allows you to bulk load user accounts - it can create work areas and configure NTFS permissions: WiseSoft - Account Management. Bulk Create User Accounts with Excel Spreadsheet. For updating existing user accounts you might find my new Bulk AD Users application useful: WiseSoft Bulk AD Users - Beta Testing!

Two separate tools, but they do have some overlapping features. Both applications model part of the interface on the user dialog in Active Directory Users and Computers. ADModify does not allow you to update via CSV or to edit account data in MS Excel. ADModify has limited support for updating multi-valued attributes and there are a number of other advantages to using my tool over ADModify. ADModify also has some useful features that you won't find in Bulk AD Users - better support for exchange attributes for example.

http://www.wisesoft.co.uk/userdata/admin/BulkADUsers_Main_small.png Beta testing for WiseSoft Bulk AD Users is now available! Hope you like the new application. Any feedback is welcome.

I don't think there is an easy way to get that information off hand. You could have an app monitoring running processes and store a date value the last time they were used. I'm not sure if there are any alternatives methods.

The script is designed to be run interactively. It is possible to do what you want but having a text/HTML report for each computer will limit the use of the information. It's better to store that information in a database (SQL Server/MySQL/Oracle - Not MS Access). You could then have another (web based?) tool to query the information in the database. e.g Show me all the computers with less than 1Gb RAM. I've done something like this before but only for in-house use. I think this app does something similar but in a slightly different way: Neutex: Network Inventory Made Simple It used to be free, but it looks like they have a limited free version and a pro version now. I'm sure there will be other s/w available that does a similar thing.

The registration system appears to be working ok. Please let me know your username (send a PM via these forums if you like) and I'll check that your account is activated.

Are you talking about a cut down version that just displays information about the local computer? HTA scripts should work ok as a startup script from a network share to display information about the local computer. I like to write new scripts occasionally for my website so it might be something I'll look at when I get chance. I'll need some more details. I've got a few other things that I'll be working on at the moment though...

I've just finished writing this script to report WMI information in HTML format: Computer Information Tool (HTA) It can also be used as a process monitor for remote computers, a tool to connect to remote shares and printers and a tool to perform remote shutdowns/reboots. I might add other items to the script in future. Hope you find the script useful! Thanks, David

Just added a chart (progress bar) to highlight the used/free disk space.

Just found an excuse to write my first HTA script - a drive space reporter tool: Drive Space Report (HTA) It can check the drive space of multiple servers and highlight any that are running low on disk space. You can also download a CSV version of the report. I thought I'd post this one here as it might help with daily checks etc.

Some people might find this useful as an alternative to CSVDE. It's an app I created a while ago that allows you to create users directly from Excel: WiseSoft - Account Management. Bulk Create User Accounts with Excel Spreadsheet. I also have an app for bulk reset of user passwords: Bulk Password Control - Reset Passwords for Active Directory User Accounts And an app (same one as above really) that allows you to update user attributes from CSV file, or use Microsoft Excel to edit user account data. You can see some of these features in action in the video below: They are all freeware apps.

Password Control version 2.4 has been released!

Thanks for the positive feedback!

A better quality version of the video is available here.

I was hoping to get the new version of Password Control released over the weekend, but there are still a few updates I need to make to my website. Hopefully this is the next best thing. Let me know if you like the video.

Hi, I think it might be because you have a user with a - at the end of their username. I wasn't aware of this XML specification requirement. I'll investigate further and include the fix in the next version of Password Control. As for the next version of Password Control, I've created a 2 minute video showcasing some new features: Password Control - New Features Preview * CSV Update * Editable GridView * Edit GridView in Excel Let me know what you think.

I'm glad people find it useful! It's always nice to get some positive feedback!

Yes. You might want to have a look at the XML Placeholders section: Bulk Modify for Active Directory - XML PlaceHolders This should work: givenName sn (student) or this displayName (student)

The release version is now available!! WiseSoft - Password Control. Active Directory Password Reset Tool. I hope you find it useful. PS Active Directory backups are still recommended before making any type of bulk change - via script or with this app.

Glad you found it useful.