Thursday, July 24, 2014

Azure - Deleting VNet

Trying to delete a Virtual Network in Azure

Powershell command:
Note this removes all Virtual Networks from your active Azure Subscription
Remove-AzureVNetConfig

But then:
Remove-AzureVNetConfig : BadRequest : Cannot delete or modify virtual network while in use 'xxxxx'.

I do not have Virtual Machines as I removed them all. But then I noticed the VNetwork has a Gateway assigned to it.

So remove the gateway before removing the VNetwork.


Delete the Gateway


By the way, the Powershell command for deleting a VNet Gateway:
Remove-AzureVNetGateway -VNetName "SPAutoVNet"


Push!

This blog just received a serious push into the future. I have been busy for the past 3 or so months with SharePoint 2013 and Azure Cloud Services.


Leaving the old technology behind and going forward, where I have not been yet!


While I believe Cloud technology has a serious place in the future (as it currently does), it has room for improvement.


On this blog I will post about my stumbles and falls with SharePoint 2013 and Azure.


Here we (or I) go!

Friday, April 20, 2012

SharePoint 2007 and InfoPath Form List

Strange thing happened the other day. A user phones and in a panic ask's "All our data is GONE on our list!" Stop the drama!

Anyway, here is the problem:

A Form Library lost all of its custom columns. Nobody deleted it. Opening the form in Infopath showed that the fields were still in the form. But the view did not show it. Not even in the library settings could you see the fields.

By luck, I think, I replicated the problem on our Application Support server.

Saving the List as a template, removed all the form columns in the list. The columns may have been removed from the view and list, but the DATA was still there.

So, here is the solution: Republish the form to the library. Open each item and view the properties. Then that will repopulate the fields .

If you experienced this, please leave a comment.

Tuesday, April 3, 2012

Who deleted that Web site?

Sometimes Web sites get deleted. If you want to track down who did it, you can check the IIS logs or check the Content DB.

The query to run on the SQL DB is:

SELECT [Id]
      ,[SiteId]
      ,[EventTime]
      ,[ListId]
      ,[ItemId]
      ,[ItemName]
      ,[ItemFullUrl]
      ,[EventType]
      ,[ModifiedBy]
      ,[TimeLastModified]
      ,[EventData]
      ,[FormattedFragment]
  FROM [].[dbo].[EventLog]
where itemfullurl like '%//%' and EventType = '4'


In the LAST row (by Date), the Column ModifiedBy will be the person that deleted the site. Just double check that the ItemFullUrl has ...'Lists/Site Owner/' ... in it. EventType 4 means 'deleted'.

I do not take responsibility for unfair dismissal. ;-)

It is however likely the person that deleted the site.