Updating from SharePoint

avatar

Hi
I am maintaining a list of internal servers in SharePoint, and it would be really cool if we could create a workflow that is run every time a new server is added, and ultimately add an entry to the session table in SQL Server.
Can this be done today, or should I add it as a feature request?
Regards
JRohde

All Comments (6)

avatar

Hi,
I'm not a SharePoint specialist, could you give me more details what I have to do in RDM to make this work?

David Hervieux

avatar
avatar

Hi David

SharePoint is a huge topic, so let me instead ask if is generally possible from a separate system/script to update the session table either through RDM, an API or directly to the SQL Server table?

Regards
JRohde

avatar

It's only an Xml document, you can generate the template and update the database directly. For the password, you can call RDM in command line to set it.

David Hervieux

avatar

Hi dhervieux

I don't get it. How do I update the SQL Server tables from an XML-file?

avatar

Hi,
It's not from an Xml file, it's with an Xml content. I mean that you load the Xml in a string and you update the the field Data with the text. The text is an xml text.

David Hervieux