In case you ever change vcenters, veeam has a nifty tool to help you migrate
I’ve been having a lot of fun experimenting with google maps and Qlikview. After looking at quite a few extensions I finally ran across this one.
Download the .qar file
(Qlikview extensions are easy to install, just double click the .qar file and it will go got town)
So, first things first. Get yourself your own google maps API key
Using your google account you can eventually get to a screen that will give you a key.
Make sure you have changed over to web view (View menu, Turn on\off web view)
Extensions only work in web view (ajax view)
Then flip yourself to the Markers tab, right click properties on the extension object, Basic Configuration and paste in your Key into the API Key.
So, next thing I wanted to do was change the icon.
To do this, locate where it installed the extension.
C:\Users\[user]\AppData\Local\QlikTech\QlikView\Extensions\Objects (vista & seven) or C:\Documents and Settings\[user]\Local Settings\Application Data\QlikTech\QlikView\Extensions\Objects.
Drop your custom icon into /lib/images/ and refer only to the filename
Under properties \ Markers \ Custom Icon URL type in just the filename of your new icon (and make sure its the right size or you will get giant markers 🙂
If you want to have different markers based on some criteria then clear your custom icon URL on the Markers tab, change over to Markers – Additional Configurations
Click Force Multi-Icon Markers
Use an if statement in your function.
I’ve been slacking a bit on my blogging 🙂
After some trial and error I was able to transfer state from one Qlikview to another using the IE plugin on the Qlikview server.
The first thing to figure out is the path to your Target Qlikview.
The easiest way to do this is to open up the qlikview on the portal and then press Control + Shift + Q (Or go to the menu of the Qlikview plugin and choose Document Support Info)
Copy that address. I’m not sure why it uses the qvp protocol, but hey this works.
Ok, now on your starting Qlikview you need to have a field that matches exactly a field in your target Qlikview. Otherwise it won’t work
So create a button, choose ‘Open QlikView Document’ paste in the URL you got from before (You can remove the qvp://qlikviewservername/ if you want)
Click Transfer State.
Now publish your starting Qlikview (the button won’t work from Qlikview desktop)
And press the button. If everything works correctly you should see selections passed from one Qlikview to the Next. (If no selections are possible on the target, nothing will happen)
Eg. MSS: (AutoAdminLogon) Enable Automatic Logon, MSS: (EnableICMPRedirect) Allow ICMP redirects to override OSPF generated routes etc
These additional group policy settings were developed by the Microsoft Solutions for Security group and are documented in the appropriate security guides.
For Windows Server 2008 is available here: http://www.microsoft.com/en-us/download/details.aspx?id=17606
1. Download Security compliance manager from here : http://technet.microsoft.com/en-us/solutionaccelerators/cc835245.aspx
2. Install SCM
3. After installing SCM, copy “LocalGPO.msi” file from the following path: “C:\Program Files (x86)\Microsoft Security Compliance Manager\LGPO\LocalGPO.msi”
4. Run and install the file “LocalGPO.msi” on the server.
5. Open command prompt and browse to : “C:\Program Files (x86)\LocalGPO”
6. Run following command “Cscript LocalGPO.wsf /ConfigSCE”
7. Now MSS Settings will be visible in Security Options in Local Group policy settings.
1. Browse to %systemroot%\inf
2. Take ownership of sceregvl.inf and full access on your ID.
3. Open sceregvl.inf using notepad.
4. Scroll down to [Register Registry Values] part and copy the contents of this file under [Register Registry Values].
5. Now browse to [Strings] part and copy the contents of this file under [Strings].
6. Save sceregvl.inf
7. Run this command on elevated command prompt “regsvr32 scecli.dll”
8. Now MSS Settings will be visible in Security Options in Local Group policy settings.
Install Group Policy Management (on a server 2008 R2 or higher)
Then you are able to run import-module grouppolicy
So, to add a computer to a ‘security filter’ you need to add GpoApply (which is both read and apply permissions) and it will then show in the security filtering pane
The command to do so is
Set-GPPermissions -Name “MyTest” -PermissionLevel GpoApply -TargetName “TheComputer” -TargetType Computer
To Remove the computer is quite simple, same command but set permissionlevel to none
Set-GPPermissions -Name “MyTest” -PermissionLevel None -TargetName “TheComputer” -TargetType Computer