Adding laptops using AD

[tashman89]

Server (please complete the following information):

• Snipe-IT 9
• OS: [Windows]
• Web Server: [IIS]
• PHP Version 7

Is your feature request related to a problem? Please describe. Now I don't have a problem .

Describe the solution you'd like Dears support team, We have about 600 laptops in our company and we need your kind advise about how we can adding them to the system using active directory or LDAP .

Describe alternatives you've considered A clear and concise description of any alternative solutions or features you've considered.

Additional context Add any other context or screenshots about the feature request here.

Br,

[tashman89]

Dear

Can anyone help me please if there is any way to add 500 laptops one time using AD or LDAP.

Br,

[ajsy]

export the data from AD, and import the file into snipe-it

[tashman89]

Thanks Ajsy

[tashman89]

Dear Ajsy ,

could you please advise if you have the steps .

Thanks

[sjackson0109]

you can use many methods of extracting AD computer related data.. 1) Microsoft Excel... Ribbon> Data>GetData>From Other Sources>From Active Directory Enter the FQDN of the domain, if not auto-populated > OK Choose the Navigator (object Class) called "computer" Use the Connections pane on the right, click EDIT and have a go at adding other columns... it's not simple, but it's really effective.

Here is an example of the 'advanced powerquery code': let Source = ActiveDirectory.Domains("local/authenticated domain name goes here"), domain name = Source{[Domain="target/trusted domain/FQDN goes here"]}[#"Object Categories"], computers = domain name{[Category="computer"]}[Objects],

"Expanded user" = Table.ExpandRecordColumn(computers, "computer", {"msDS-User-Account-Control-Computed", "userAccountControl"}, {"user.msDS-User-Account-Control-Computed", "user.userAccountControl"}),

#"Removed Other Columns" = Table.SelectColumns(#"Expanded user",{"user.userAccountControl", "computer", "displayName"})

in

"Removed Other Columns"

2) Microsoft Powershell... Start>Run>Powershell.exe Import-Module ActiveDirectory Get-ADComputer -Filter -Property | Select-Object Name,OperatingSystem,OperatingSystemVersion,ipv4Address | Export-CSV ADcomputerslist.csv -NoTypeInformation -Encoding UTF8

3) Old-School Command line version of DSQuery: Start>Run> CMD DSQUERY COMPUTER "OU=servers,DC=mydomain,DC=com" -o rdn -limit 1000 > c:\machines.txt

4) Windows GUI version of DSQuery: Start>Run> %SystemRoot%\SYSTEM32\rundll32.exe dsquery,OpenQueryWindow Find menu > Computers Click Find I don't think you can save via this method anymore, but you can do with ADUC (start>run>dsa.msc) but you need 'Remote Server Administration Tools' installed on your client.

[stale[bot]]

Is this still relevant? We haven't heard from anyone in a bit. If so, please comment with any updates or additional detail. This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Don't take it personally, we just need to keep a handle on things. Thank you for your contributions!

[sjackson0109]

Yes, importing assets autonomously from AD would be tremendously useful.

I’ve worked for several MSPs; and most of them advise clients to use computer naming conventions matching:

Hostname: <serial/tag>

I also have introduced dozens of auto-startup GPO power shell/VBA riots to collect local hardware data (make/model/Mac/audio device/battery status etc) and put the data within the AD computer object.. there are dozens of Pre-existing fields, although these can be easily expanded upon - suggest doing it in a lab first)..By sync’ing AD computers (objectclass=computer) for a given OU, it would save on the manual extract/cleanup in excel and re-import.

Also - AD computer objects have a ManagedBy attribute (similar to Manager for user objects).. where most MSPs assign the end user. It’s a multi-valued array, but the ADUC gui doesn’t let you add more than a single value DN in that attribute.

On 25 Dec 2020, at 18:23, stale[bot] notifications@github.com wrote:

 Is this still relevant? We haven't heard from anyone in a bit. If so, please comment with any updates or additional detail. This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Don't take it personally, we just need to keep a handle on things. Thank you for your contributions!

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or unsubscribe.

[stale[bot]]

Okay, it looks like this issue or feature request might still be important. We'll re-open it for now. Thank you for letting us know!

[alex13p]

Will this ever get added?