export lotus notes dns/IPAM data

richsark
richsark used Ask the Experts™
on
I need a way to export all the IP/DNS data from Lotus notes into a workable csv format. is there a sql command or a way to get this out?

I see that t the export of LN to .csv format is screwed up due to the way LN handles Carriage Returns.

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Sjef BosmanGroupware Consultant

Commented:
Please help me here: what exactly do you want? AFAIK there is no real DNS or IP info in Notes... There may be some cached values here and there, but Notes (or a Domino server) doesn't have DNS capabilities.

Which database are you referring to, and which view? Or where are you looking?

Commented:
The built-in CSV export doesn't work very well, but I wouldn't use it anyway because users want a nicer UI. You can easily code up this kind of thing in LotusScript.

Author

Commented:
great. do you have such script?
Sjef BosmanGroupware Consultant

Commented:
A script to do what exactly?

Author

Commented:
Hi, just to pull any relevent DNS/IP address data. If it cant be done. then lets close this
Groupware Consultant
Commented:
I really don't understand what you're looking for. What is "relevant"?? Yes, there are IP addresses, but in the logs. Yes, there is some DNS information, also in the logs. But maybe you have a special database on your server, with IP and DNS info, I don't know. Any standard server does not store IP or DNS info in a structured way.

Author

Commented:
HI, Never mind, I was told that the info was in Lotus notes DB.

Anyway I will close this.

Thanks for everyone's input

Author

Commented:
Not resolved

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial